vlookup tables
i have 20 separate spreadsheets - one for each cost center - the spreadsheets
show actuals for the months July through nov. i want to add december's
actuals. i know that i can download the dec actuals into an excel
spreadsheet and do a vlookup to put them in dec. every time that i've done a
vlookup i have put the table in the same spreadsheet. since i don't want to
copy this table to 20 spreadsheets i want to know if it's possible to have
the table in a separate spreadsheet.
thanks in advance for your help. your suggestions in the past have been
VERY helpful.
--
aprilshowers
|