Creating cell links between workbooks

  • Thread starter Thread starter Rhema
  • Start date Start date
R

Rhema

I am linking cells between workbooks using the "=" sign in the recipient
cell, and clicking the cell in donor cell.

This produces the below formula.

=[ISDNAct.xls]ISDNActNov03_Oct04!$E$21

Is it possible to select multiple cells at once on the recipient
workbook, and paste links between the donor workbook?

Thanks in anticipation
 
I'm not sure exactly what you're getting at (I'm a little slow!)?

The formula in your note will copy the value of cell "$E$21" from the sheet
"ISDNActNov03_Oct04" located in the
Workbook book "ISDNAct.xls" (the Donor, in your parlance) and place the
value in whatever cell you've got the formula in ("Recipient").

If you want to copy a range and they are contiguous (say E21 to E100, for
ex) then remove the $ sign from the row reference in $e$21 (ie make it
$e21).
Assuming you are copying to a contiguous range then simply grab the fill
handle and drag it down to copy the formula to all the cells. The row
numbers from the "donor" sheet will automatically increment by one (E21,
E22, E23 etc).

Hope I'm not too far of base.

--
Regards;
Rob

Please reply to the NG, I'm already up to my eyeballs in Nigerian/South
African get rich letters
as well as "Microsoft Critical Updates" et al.
 
Back
Top