Copy data from one tab to the next... read more

A

Angela G

I would like to have multiple user's data on their tab be automaticly filled in on all the tabs...
for instance -
next steps filled in all all 12 tabs as they type it on theirs

Can I do this? Is this a macros? is there a formula for this? - I want it to do it automatically without having to teach the user anything - or expect the user to follow any steps (so highlight tabs won't work)...

Thanks in advance
 
F

Frank Kabel

Hi
you have to enter a formula in each of the cells in the other
worksheets referencing the first sheet. something like
='sheet1'!A1
 
A

Angela G

You're a gem - worked like a charm!
A

Frank Kabel said:
Hi
you have to enter a formula in each of the cells in the other
worksheets referencing the first sheet. something like
='sheet1'!A1
Click to expand...
 
Top