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

[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

 

[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

 

[Angela G]

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

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