Report

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

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

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!