Thread: vlookup tables
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
april april is offline
external usenet poster
 
Posts: 111
Default 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