Duplicating data from one line on sheet 1 to sheet 2

Solved/Closed
Buford - Mar 17, 2016 at 05:35 PM
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 - Mar 19, 2016 at 01:15 AM
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

martel_9 Posts 2 Registration date Wednesday March 16, 2016 Status Member Last seen March 17, 2016
Mar 17, 2016 at 05:51 PM
Hi
Could you please let us know by "Data in a box"?
0
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.
0
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 252
Mar 18, 2016 at 02:59 AM
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.
0
Thanks VCoolio - it worked great.
0
Blocked Profile
Mar 18, 2016 at 04:44 PM
NIce! Simple! Love it! Nice job VCoolio!
0
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 252
Mar 19, 2016 at 01:15 AM
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.
0