View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joec[_2_] joec[_2_] is offline
external usenet poster
 
Posts: 14
Default merging data/worksheets

I am charged with combining data from 12 different excel workbooks into one
worksheet. Each workbook has data entered on 5 different worksheets. All of
the column headings are identical. What I need is for certain results from
each worksheet to merge into 1 worksheet without overriding each other. And
with the ability to add more data at a later time. Is this possible to
achieve?
--
joec