View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lem
 
Posts: n/a
Default How to consolidate worksheets (1 file) with different headers?

I'm attempting to consolidate sales leads from multiple worksheets, all w/
different headers (downloaded from different areas hence diff headers) and
place that filtered info into a new Excel file. I want all info from the
original but need to put them in different geographic based tabs. Need
query? Pivot table? I do not know much about either. Thank you.