Thread: Collate data from one spreadsheet into another spreadsheet
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 Collate data from one spreadsheet into another spreadsheet
Excel 2007 Tables
Extract data from 2 tables and consolidate.
No formulas or code used.
Ranges dynamic.
Assumes account# appears only once.
http://www.mediafire.com/file/mfgno0h0yte/10_19_09.xlsx
Reply With QuoteReply With Quote