Report

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

Ask a question Buford - Last answered on Mar 19, 2016 at 01:15 AM by vcoolio
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 
Helpful
+0
plus moins
Hi
Could you please let us know by "Data in a box"?
Buford- Mar 17, 2016 at 06:06 PM
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.
Helpful
+0
plus moins
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.
Buford- Mar 18, 2016 at 04:42 PM
Thanks VCoolio - it worked great.
ac3mark 7121Posts Monday June 3, 2013Registration date ModeratorStatus June 27, 2017 Last seen - Mar 18, 2016 at 04:44 PM
NIce! Simple! Love it! Nice job VCoolio!
Helpful
+0
plus moins
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.

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!