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

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Tommy Bak

Active Member
Joined
Feb 25, 2002
Messages
288
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
 

kskinne

Well-known Member
Joined
Feb 17, 2002
Messages
1,267
Office Version
  1. 365
Platform
  1. Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,130,119
Messages
5,640,219
Members
417,131
Latest member
Seanr19871

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
Top