pulling data from multiple workbooks

[Leal72]

Thank you in advance to taking a look at this.

I have a series of workbooks with mutliple sheets in each. One of the sheets in these workbooks has a common name "Part Info". This is the sheet I need to pull data from, part numbers, prices, location, etc.. The info I need is in cells (D24, G6, D8, E15, F35, and so on) in the "Parts Info" sheet. I want to take the data that is being pulled from these sheets and place it in an existing workbook called "Parts List" and sheet named "summary sheet". The dat on the summary sheet will be all on the same row, column A through Z. This is the only part of code I have that works. I'll have to add a part at a time after the intail setup and need the info to be place under the last row of data.

Please Login or Register  to view this content.

[Leal72]

-----bump-----

Is more info needed?

[Leith Ross]

Hello Leal72,

Here is a macro that will copy the data from sheet named in the variable DataSheet to the summary sheet named in the variable SummarySheet.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[Leal72]

Thank for your response, is it possible to select specific cells, rather than the full sheet (DataSheet)?

I need for SummarySheet column A (next available row) to have the info from DataSheet cell D24

[Leith Ross]

Hello Leal72,

Here is the revised macro. The only 2 variables you need to change in the macro are the DataSheet and DataRng. Change these to the worksheet name and cells you want to use. All the cells will be copied across row 1 starting with in column A on the SummarySheet and moves down a row for each workbook.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[Leal72]

thank so much. That did the trick.