Duplicating data from one line on sheet 1 to sheet 2

[Solved/Closed]
Report
-
Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
-
Hello,

I'm looking for help, I have data in one box on sheet1 one that when I update that data I would like for it to automatically change in a box on sheet2, sheet 3 etc.

Can anyone help me with this? Thanks



3 replies

Posts
2
Registration date
Wednesday March 16, 2016
Status
Member
Last seen
March 17, 2016

Hi
Could you please let us know by "Data in a box"?
Sorry about that, If I add data to a cell and would like that data to automatically update in a cell located on sheet2, sheet3, etc.
Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
239
Hello Buford,

If it is just one cell that you want to update in each sheet, then this simple formula should suffice:-

=Sheet1!A1


Place the same formula in each required cell in each sheet (except your input sheet, sheet1) and as the data in the cell in sheet1 updates, so will the other cells in each other sheet, instantly. I have used cell A1 as a guide so change this to suit yourself.

If there is a little more that you need to tell us, then please upload a sample of your work book showing inputs and the expected results. You can upload a sample to a free file sharing site such as DropBox, ge.tt or SpeedyShare then post the link to your file back here. Be careful with any sensitive data.

I hope that this helps.

Cheerio,
vcoolio.
Thanks VCoolio - it worked great.
Blocked Profile
NIce! Simple! Love it! Nice job VCoolio!
Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
239
Hello Buford,

That's great! Glad that I was able to help out.

@ ac3mark:-

Thanks for dropping in and the compliment. Nothing quite like receiving the thumbs up from a fully fledged Programmer!

Cheerio people,
vcoolio.