PDA

View Full Version : find data from one workbook to another workbook



rocheey
05-29-2008, 10:12 AM
I have some workbooks created by others, the format of these workbooks cannot change.

In the first of these workbooks, say "WorkBook 1", there is data written in columnar format on Sheet "1A".

In this same first workbook, but on Sheet "1B", there is a formula written that uses the INDIRECT function to access the data on sheet "1A". Each of the cells on Sheet "1B" that use this function, (all in the same column), each have a unique name (named RANGE).

A second WorkBook, accesses the value of the cells on Sheet "1B" of the first (external) workbook using the '[WorkBook].NamedRange' format.

My question is, is there a way, from WorkBook 2, to get the value of the cell in the Column NEXT to '[WorkBook].NamedRange' in Workbook 1?

Thanks in advance, and help yourself to my aspirin ....

grichey
05-29-2008, 10:31 AM
Do you have an example .xls you can attach? I'm having trouble visualizing this one...

gwkenny
05-29-2008, 10:32 AM
offset() will do what you need.

Your explanation though gave me a headache!!! lol