collect data from the same row in multiple spreadsheets

G

Guest

I have 140 employees with a separate workbook for each.The workbooks contains
their by-weekly timesheets. Each workbook has 26 sheets (one for each pay
period).

I need to start a workbook that will contain the total line for each
employee (line 37). For instance, The first sheet in each workbook in named
"july 3". I need to collect line 37 from each July 3 sheet (total 140 lines)
and have them show in the new workbook on the "july 3" sheet.

I have to do this 26 times to complete the new workbook. Does anyone know
of a shortcut?
 

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

correlating and summing data from multiple spreadsheets 1
Collect used areas of multiple spreadsheets into one... 1
Multiple sheets 5
transferring data to new multiple spreadsheets 1
Excel, assign cells in multiple worksheets from one sheet 1
How can collect data from multiple sheets in the same workbook? 1
Join workbooks 3
Copy range to multiple workbooks 2

Top