Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kiwi Mike
 
Posts: n/a
Default 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
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

Do you have both workbooks open?

If the referenced workbook is closed, then =INDIRECT() won't work.

Harlan Grove wrote a UDF that allows you to retrieve values from a closed
workbook when you build that string that points at the
drive/folder/filename/sheetname/range address.

http://www.google.com/groups?selm=sH...wsranger. com

And more here for alternatives from Harlan and Frank Kabel.........

http://snipurl.com/awej


Gord Dibben Excel MVP



On 25 Nov 2004 17:04:57 -0800, (Kiwi Mike) wrote:

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


  #3   Report Post  
Kiwi Mike
 
Posts: n/a
Default

Hi Gord

I do have the referenced workbook open but I still seem to get that
error. The referenced workbook is shared - I'm not sure if that would
complicate matters. Thanks for the effort.

Mike

Gord Dibben <gorddibbATshawDOTca wrote in message . ..
Do you have both workbooks open?

If the referenced workbook is closed, then =INDIRECT() won't work.

Harlan Grove wrote a UDF that allows you to retrieve values from a closed
workbook when you build that string that points at the
drive/folder/filename/sheetname/range address.

http://www.google.com/groups?selm=sH...wsranger. com

And more here for alternatives from Harlan and Frank Kabel.........

http://snipurl.com/awej


Gord Dibben Excel MVP



On 25 Nov 2004 17:04:57 -0800, (Kiwi Mike) wrote:

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"