Hi,

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.

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

Hi AliceJ,

Could you provide an example workbook so we can see exactly what you're trying to acheive?

Thanks.

S.

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Hi Sir, I just attached the file here. As an example,

I have a worksheet A, and I also have a workbook B.

I want to find a unique text string, called "ID code" in file A!Sheet1.

Let us assume it is found in cell J21 on the tab A!Sheet1, then I want that the cells J21 through J30 should be copied and pasted in sheet 1 of file B, in cells say A1 through A10.

So, the following are specified:

1.The text string "ID code" to be searched for;

2.The number of target cells to be copied to B!Sheet

Can you please help?

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

Alice