R
rgmw
I have a Master workbook, which I would like to pull in information
from other workbooks for a project. Each project manager will deal
with a particular workbook, within the same directory. That's no
biggie, but what I would like to do easily is, If I add another
project manager, I'll need another workbook, so instead of updating
all the formulas manually, I would like the master workbook to be
"smart" enough to pull in the data.
Generally, I was thinking, either:
a) have a list within the workbook of all the workbooks within the
same directory, so all I need to do is add another file name to the
list and the master workbook would update its formulas,
b) or, better yet, be smart enough to "see" all the files w/in the
directory and update the formulas if needed.
Any ideas or recommendations? Thank you . . .
Rich
from other workbooks for a project. Each project manager will deal
with a particular workbook, within the same directory. That's no
biggie, but what I would like to do easily is, If I add another
project manager, I'll need another workbook, so instead of updating
all the formulas manually, I would like the master workbook to be
"smart" enough to pull in the data.
Generally, I was thinking, either:
a) have a list within the workbook of all the workbooks within the
same directory, so all I need to do is add another file name to the
list and the master workbook would update its formulas,
b) or, better yet, be smart enough to "see" all the files w/in the
directory and update the formulas if needed.
Any ideas or recommendations? Thank you . . .
Rich