How to read data from the workbook selectively?

[AliceJ]

Hi,

It's been interesting to me on how to read data selectively from th
other workbook. Rather than pull all data, I just want to read values o
10 cells: the 1st cell has a unique name "ID code", and from this cel
downward to the 10th cell.

Though this seems to be easy, I cannot get this work. Any one can mak
an example to solve this interesting one

 

[Claus Busch]

Hi Alice,

Am Wed, 16 Jan 2013 12:54:00 +0000 schrieb AliceJ:

It's been interesting to me on how to read data selectively from the
other workbook. Rather than pull all data, I just want to read values of
10 cells: the 1st cell has a unique name "ID code", and from this cell
downward to the 10th cell.

open the other workbook too.
In new workbook in first cell:
=OldWorkbookName.xlsl!ID_code
In second cell:
=IF( ROW(A1)<10,OFFSET(OldWorkbookName.xlsm!ID_code,ROW(A1),),"")
and copy down to the 10. row
Close the old workbook and the path will be updatet automatically.


Regards
Claus Busch

 

[Claus Busch]

Hi Alice,

Am Wed, 16 Jan 2013 15:59:45 +0100 schrieb Claus Busch:

=OldWorkbookName.xlsl!ID_code ......................................^^^^^^

=OldWorkbookName.xlsx!ID_code

=IF( ROW(A1)<10,OFFSET(OldWorkbookName.xlsm!ID_code,ROW(A1),),"")

.......................................................................................^^^^^^^^
=IF( ROW(A1)<10,OFFSET(OldWorkbookName.xlsx!ID_code,ROW(A1),),"")


Regards
Claus Busch

 

[Claus Busch]

Hi Alice,

Am Wed, 16 Jan 2013 15:59:45 +0100 schrieb Claus Busch:

=IF( ROW(A1)<10,OFFSET(OldWorkbookName.xlsm!ID_code,ROW(A1),),"")

you better work with cell references. With OFFSET or INDIRECT you have
to open the old Workbook to get the formula to work.
if ID_code is in A1
In your first cell:
=OldWorkbookName.xlsx!A1
and copy down 10 cells


Regards
Claus Busch

 

[AliceJ]

Hi Alice,

Am Wed, 16 Jan 2013 15:59:45 +0100 schrieb Claus Busch:
-

you better work with cell references. With OFFSET or INDIRECT you have
to open the old Workbook to get the formula to work.
if ID_code is in A1
In your first cell:
=OldWorkbookName.xlsx!A1
and copy down 10 cells


Regards
Claus Busch

The trouble is we don't know where is 'ID Code' located. So it is not a
simple as that

Alic

+-------------------------------------------------------------------
+-------------------------------------------------------------------