H
Hank Youngerman
I have a workbook that pulls a lot of external links. They always
come from the same location in other sheets. Imagine that I have
another workbook that has sheets "Price List As of 1-07," "Price List
As of 2-07" etc. The in this workbook, I have a sheet with "Current
Value Of Inventory" and in cell A1 I always want the current price of
Item #1. So the reference might be to the Price List workbook, and
the 4-07 tab today, the 5-07 tab next month, etc.
Is there a simple way to just put the name of the associated sheet in
a cell, and let it update that way? I tried the "indirect" function,
but it didn't seem to work with an external reference.
come from the same location in other sheets. Imagine that I have
another workbook that has sheets "Price List As of 1-07," "Price List
As of 2-07" etc. The in this workbook, I have a sheet with "Current
Value Of Inventory" and in cell A1 I always want the current price of
Item #1. So the reference might be to the Price List workbook, and
the 4-07 tab today, the 5-07 tab next month, etc.
Is there a simple way to just put the name of the associated sheet in
a cell, and let it update that way? I tried the "indirect" function,
but it didn't seem to work with an external reference.