Duplicating data from one line on sheet 1 to sheet 2
Solved/Closed
Buford
-
17 Mar 2016 à 17:35
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 19 Mar 2016 à 01:15
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 19 Mar 2016 à 01:15
Related:
- Duplicating data from one line on sheet 1 to sheet 2
- How to copy data from one excel sheet to another - Guide
- Excel move data from one sheet to another - Guide
- Tentacle locker 2 - Download - Adult games
- Little alchemy cheat sheet - Guide
- How to copy data to multiple worksheets in Excel - Guide
3 responses
martel_9
Posts
1
Registration date
Wednesday 16 March 2016
Status
Member
Last seen
17 March 2016
17 Mar 2016 à 17:51
17 Mar 2016 à 17:51
Hi
Could you please let us know by "Data in a box"?
Could you please let us know by "Data in a box"?
vcoolio
Posts
1411
Registration date
Thursday 24 July 2014
Status
Contributor
Last seen
6 September 2024
262
18 Mar 2016 à 02:59
18 Mar 2016 à 02:59
Hello Buford,
If it is just one cell that you want to update in each sheet, then this simple formula should suffice:-
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.
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.
vcoolio
Posts
1411
Registration date
Thursday 24 July 2014
Status
Contributor
Last seen
6 September 2024
262
19 Mar 2016 à 01:15
19 Mar 2016 à 01:15
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.
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.
17 Mar 2016 à 18:06