importing specific cells from multiple workbooks into 1 workbook

  • Thread starter Thread starter Walter Davis
  • Start date Start date
W

Walter Davis

I need to compile data from 6 cells in the 2nd tab in over 300 workbooks that
are in the same folder into 1 spreadsheet in a separate workbook.I want to
insert a new row for the data from every workbook. All of the workbooks have
the exact same format. Anyone know the easiest way to get this info compiled?
 
Anyone ever tell you that YOU ARE THE MAN!? Thanks. You just saved a whole
days work...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Import multiple workbooks to current workbook in specified row number 0
Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
how to stop data shifting into new cells every time workbook is o. 1
Excel 2003: Copy rows from one workbook into another without losinginterleaved data 3
Is there a way to referance data from or to a closed workbook from 5
Importing range of cell values from several workbooks to one 2

Back
Top