tryingexcel
New Member
- Joined
- Apr 2, 2002
- Messages
- 2
I am trying to create a dynamic range that
will change each time my project list changes.
I have seen some code that allowed me to capture the range as the following:
=OFFSET($A$1,0,0,COUNTA($A:$A),4)
(In the Define Name box I called it myRange)
What I need to do is: have another workbook
(when it is called from the first workbook) use the VLOOKUP table to be able to use myRange to find the value I want. I keep
getting errors. Any suggestions, I am kind of new at this. Thanks
Below is a sample of the first Workbook
FY 2001 MY Project List
PROJ NBR PROJ NAME BR NBR BR CHIEF
0176 Demographic LAN Support 18 Lau
0902 Division InterProject 02 Kreilick
0906 CPS 44 Tucker
0937 LEHD 04 Prevost
This message was edited by tryingexcel on 2002-04-03 08:00
This message was edited by tryingexcel on 2002-04-03 08:20
will change each time my project list changes.
I have seen some code that allowed me to capture the range as the following:
=OFFSET($A$1,0,0,COUNTA($A:$A),4)
(In the Define Name box I called it myRange)
What I need to do is: have another workbook
(when it is called from the first workbook) use the VLOOKUP table to be able to use myRange to find the value I want. I keep
getting errors. Any suggestions, I am kind of new at this. Thanks
Below is a sample of the first Workbook
FY 2001 MY Project List
PROJ NBR PROJ NAME BR NBR BR CHIEF
0176 Demographic LAN Support 18 Lau
0902 Division InterProject 02 Kreilick
0906 CPS 44 Tucker
0937 LEHD 04 Prevost
This message was edited by tryingexcel on 2002-04-03 08:00
This message was edited by tryingexcel on 2002-04-03 08:20