View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cgy cgy is offline
external usenet poster
 
Posts: 4
Default Collate data from many workbooks

I have approx 500 workbooks that I need to collate data from into one
workbook. The data is in the same cells in each of the workbooks and needs to
be in a list in the new workbook