hi i have a lot of different excel work books at work, utilization, expenditure reports.
anyway i need to take some values out of one work book and have them in a different one, but i'd like it to be automated, something like an advanced look up, or index function.
is there anyway i can do this? also can i specify which sheet to use in the offline workbook?
any help is much appreciated