Duplicating data from one line on sheet 1 to sheet 2 [Solved/Closed]

Buford - Mar 17, 2016 at 05:35 PM - Latest reply: vcoolio 1159 Posts Thursday July 24, 2014Registration dateModeratorStatus March 28, 2018 Last seen
- 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



See more 

6 replies

martel_9 2 Posts Wednesday March 16, 2016Registration date March 17, 2016 Last seen - Mar 17, 2016 at 05:51 PM
0
Helpful
1
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.
vcoolio 1159 Posts Thursday July 24, 2014Registration dateModeratorStatus March 28, 2018 Last seen - Mar 18, 2016 at 02:59 AM
0
Helpful
2
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.
ac3mark 9176 Posts Monday June 3, 2013Registration dateModeratorStatus April 20, 2018 Last seen - Mar 18, 2016 at 04:44 PM
NIce! Simple! Love it! Nice job VCoolio!
vcoolio 1159 Posts Thursday July 24, 2014Registration dateModeratorStatus March 28, 2018 Last seen - Mar 19, 2016 at 01:15 AM
0
Helpful
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.