collecting data from multiple sheets

  • Thread starter Thread starter Cindy E
  • Start date Start date
C

Cindy E

I have a workbook with about 150 tabs, each named for a particular customer.
I need to consolidate the data by gathering row 113 from each sheet to a
summary sheet. I read the posts on linking multiple cells, but my ability to
adapt a macro for my needs is very limited currently.

I appreciate any help I can get.

Thanks,

Cindy
 
Thank you. It worked for most, but stopped pasting at row 203, with about 10
tabs left to go. It did most of the work, so I saved a lot of time.

Thanks, Cindy
 

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

How can collect data from multiple sheets in the same workbook? 1
Summarise data on multiple sheets 1
Need macro to consolidate all sheets in workbook 1
Linking multiple sheets to one master 5
Collect data from spesific cell in multiple sheets 4
Summarize data from multiple sheets 2
Copy cells from 4 w'sheets in multiple w'books to 1 w'sheet in 1 w'book 0
consolidate workbooks to worksheets in one workbook? 1

Back
Top