V
Valeria
Hi,
my problem refers to creating a specified subset of a workbook in
another workbook. I hope somebody can help me!
I have two workbooks, A and B, B is a database and I want to import in
workbook A some cells of B that are around a specified cell.
(specified in A and lookedup in B).
The OFFSET function does not seem to work in this case, because I
can't give any fixed reference cell (as for ex. "$A$1"), as this cell
is basically a looked up value coming from workbook B.
To give an ex:
Workbook A (lookup) Workbook B (initial database)
lookup value: 2 1 r y v d
u u o
looked up range: 2 a n s e v
2 a n s e v p k
p k
3 d a k m o
the OFFSET would have to refer to the "2" cell in Workbook B, and not
A, for me to get the right cells. I can get its address through
formulas but as said it does not seem to work (OFFSET would not accept
the formula). I can't use any filtering either as data has to refresh
automatically.
Is there a way I can perform this without using VBA?
Many thanks for your help.
Regards,
Valeria
my problem refers to creating a specified subset of a workbook in
another workbook. I hope somebody can help me!
I have two workbooks, A and B, B is a database and I want to import in
workbook A some cells of B that are around a specified cell.
(specified in A and lookedup in B).
The OFFSET function does not seem to work in this case, because I
can't give any fixed reference cell (as for ex. "$A$1"), as this cell
is basically a looked up value coming from workbook B.
To give an ex:
Workbook A (lookup) Workbook B (initial database)
lookup value: 2 1 r y v d
u u o
looked up range: 2 a n s e v
2 a n s e v p k
p k
3 d a k m o
the OFFSET would have to refer to the "2" cell in Workbook B, and not
A, for me to get the right cells. I can get its address through
formulas but as said it does not seem to work (OFFSET would not accept
the formula). I can't use any filtering either as data has to refresh
automatically.
Is there a way I can perform this without using VBA?
Many thanks for your help.
Regards,
Valeria