Copying Data/table from one sheet to other [Closed]

Report
-
Posts
1892
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
March 4, 2021
-
Hello,

I have copied data from one sheet to another. When I deleted from first sheet this is automatically deleted from seecond sheet

2 replies

Posts
1892
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
March 4, 2021
142
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.
Thanks for your response but this is not the case. I selected table from sheet one, used copy command and copied in sheet 2 without any link to sheet one cells. When I delete table in sheet 1 the table in sheet 2 deleted automatically
Posts
1892
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
March 4, 2021
142
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!