• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 182
  • Last Modified:

LINK Data from one worksheet to other worksheets.

Hello Experts,

I have attached a file here with consoliated all worksheets into one worksheet name "ALL".   So I accomplished this task successfully by suing the VBA code from Thomas at Expert Exchange.

 Now I need to link the data.  When I make some changes to worksheet "ALL" , I need to show that all other worksheets are automaticly updated as well.  How can I do this?

Thanks in advance.

Kathryn
Test-1.xls
0
KathrynT
Asked:
KathrynT
2 Solutions
 
KathrynTAuthor Commented:
Hello,

Can someone out there help me?  I usually receive an answer within 30 mininute.  I've been waited for 2 hours already.

Thanks...

Kathryn  
0
 
Michael FowlerSolutions ConsultantCommented:
Kathryn

Each time the macro is called it creates a new consolidation sheet and so removes any work sheet change events that could be created.

Now the consolidation has been completed do you need to run this script again?

Michael
0
 
Saqib Husain, SyedEngineerCommented:
Kathryn,

For a given row in sheet "All", how do we know which of the other sheets does the data belong to? At first I thought I would use the manager name but then there are two sheets which have the same manager.

Saqib
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now