Transferring cell content between workbooks using cell references
Gromit wrote in message ...
Hi
Assuming your list is in column A, type "[workbook.xls]worksheet!" in
cell b1 and =INDIRECT(b$1 & a1) in cell c1.
Then drag down cell c1 to fill in the correct references.
G
Gromit
I see where you're coming from and I've tried it but its returned the
#REF error. Not sure why as the formula seems to be the one I'm
looking for. Any thoughts?
Cheers,
Mike
|