Copying sheet

alienboss

New Member
Joined
Sep 5, 2002
Messages
2
Hello,
I need to copy a sheet to another book, But I want the copied sheets cell's to be updated from the original, the sheet has 500 cells and I dont want to make a link to the original cells manually.

Any help would be appreciated.
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Hi
have you tried to copy and then on the mew sheet PASTE SPECIAL and choose PASTE LINKS (the button placed at the left side of the bottom of the form)

regards Tommy
 
Upvote 0
if you want each cell in the new sheet to be linked to each cell in the original, why not just insert a formula in cell A1 to link to cell A1 in the original sheet, make sure that the cell references in the formula are not absolute references (i.e., remove the dollar signs), then copy this cell and paste it to the other 499 cells in your sheet. the cell references linking to the other sheet will be updated for each respective cell. also, you could next this link formula inside an if statement, so that if the cell in the original sheet was blank, the linked formula will return a blank, like this:

if([book1.xls]sheet1!A1="","",[book1.xls]sheet1!A1)

HTH
kevin
 
Upvote 0

Forum statistics

Threads
1,216,100
Messages
6,128,824
Members
449,470
Latest member
Subhash Chand

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top