View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default linking between spreadsheets

Excel 2007
Advanced Filter, Macro.
Filters multiple Tables into one Table.
Separate tabs for all Tables.
Example uses a single workbook.
http://rapidshare.com/files/225805908/04_24_09.xlsm