W
West
I am using a vlookup to retrieve info from other files (number of hour
spent on a specific job number for each timesheet). I am using INDIREC
to specify the RANGE for the VLOOKUP as I want to access many file
(employee timesheets).
I am using a CONCATENATE to build file names for all the timesheets fo
each employee for each time period (i
I:\timesheets\GORD\2004-11-01.xls)- this is the cell that the INDIREC
function points to for the range of the VLOOKUP.
This is close to working for me except that INDIRECT requires al
external files to be open othewrwise it returns a #REF! - it's totall
impractical to open all timesheets for every employee for eac
timeperiod!!
does anyone have any ideas on how to do this?
thanks,
West
spent on a specific job number for each timesheet). I am using INDIREC
to specify the RANGE for the VLOOKUP as I want to access many file
(employee timesheets).
I am using a CONCATENATE to build file names for all the timesheets fo
each employee for each time period (i
I:\timesheets\GORD\2004-11-01.xls)- this is the cell that the INDIREC
function points to for the range of the VLOOKUP.
This is close to working for me except that INDIRECT requires al
external files to be open othewrwise it returns a #REF! - it's totall
impractical to open all timesheets for every employee for eac
timeperiod!!
does anyone have any ideas on how to do this?
thanks,
West