Mastersheet update

Posted by Loon on January 29, 2002 9:40 AM

HI
I want to have one master sheet and 3 individual sheets for 3 seperate people
every time the the individual sheet is updated I want the master dheet updated too

I have made a start and it works but Im sure there is a quicker way than Im doing at the moment

I find the cell I want on the master press = then go to the cell I want in the individual sheet press enter and it copys the code and a link to theat cell
Obviously its time consuming as there are many cells

Thanks

Posted by Julia on January 30, 2002 8:08 AM

Loon, I am trying to find out how to do this too but can't get an answer. I have been trying to share workbooks and then use the Merge function but merge overwrites data that has the same rows number. I wish someone would help!

Posted by Helen on February 01, 2002 10:47 AM

Have you looked into LookUps? Depending if the information you want to match is on the master file? That way you'd be able to copy the lookup to all cells, and when the master sheet updates so will the others you have linked it to?

Without a specific example worksheet I am unsure what other formulae etc might help, but I'm sure there are loads of options.

Hope this helps.