Copying Data/table from one sheet to other
Closed
MI
-
Nov 17, 2016 at 10:05 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Nov 17, 2016 at 11:11 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Nov 17, 2016 at 11:11 AM
Related:
- Copying Data/table from one sheet to other
- Transfer data from one excel worksheet to another automatically - Guide
- Google sheet right to left - Guide
- Tmobile data check - Guide
- School time table software free download full version - Download - Organisation and teamwork
- Little alchemy cheat sheet - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Nov 17, 2016 at 10:20 AM
Nov 17, 2016 at 10:20 AM
MI, Good afternoon.
"...I have copied data from one sheet to another..."
How did you copy the data?
Did you use a formula?
Sheet1 -> A1 = 10
Sheet2 -> B10 = Sheet1! A1
If it was that way then you did not copy it.
You have made a link from one cell to another.
Everything that happens with the cell in Sheet1 will be replicated on sheet2.
"...I have copied data from one sheet to another..."
How did you copy the data?
Did you use a formula?
Sheet1 -> A1 = 10
Sheet2 -> B10 = Sheet1! A1
If it was that way then you did not copy it.
You have made a link from one cell to another.
Everything that happens with the cell in Sheet1 will be replicated on sheet2.
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Nov 17, 2016 at 11:11 AM
Nov 17, 2016 at 11:11 AM
MI,
It is a very strange behavior of Excel in this case.
If you prefer, save your spreadsheet with the two tables in it, in a free website, www.sendspace.com, and place the download link here.
I will download it and then I will delete the table in tab 1 to see if in my Excel this same error happens.
I believe this will be the most efficient way to help you.
It is a very strange behavior of Excel in this case.
If you prefer, save your spreadsheet with the two tables in it, in a free website, www.sendspace.com, and place the download link here.
I will download it and then I will delete the table in tab 1 to see if in my Excel this same error happens.
I believe this will be the most efficient way to help you.
Nov 17, 2016 at 10:52 AM