View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ian123[_7_] ian123[_7_] is offline
external usenet poster
 
Posts: 1
Default Combining workbooks into one?????

Hi,

I often receive data in several workbooks that i have to open and cop
to a new workbook so as to be able to evaluate the data in compariso
with each other.

Is it possible to use programming (or any other way) to simplify th
process so that on clicking a button or running a macro will collec
each of the sheets from the desired workbooks and copy them to a ne
workbook?

Any help would be much appreciate

--
Message posted from http://www.ExcelForum.com