How to consolidate all worksheets data into 1 worksheets?

J

Janet L

Hi I have a problem with the consolidating of 30 over worksheets data into 1
worksheet. As I am thinking to using the faster way likes Macro to sort it
out for me but I don't know how to do it. Can someone helps to write the
macro formula for me? Also, each worksheets data row might not be the same
and hope that macro can helps to sort out the data and consolidate it.
 

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

Help on consolidate worksheets from different workbooks into one 2
consolidate workbooks to worksheets in one workbook? 1
consolidate multiple worksheets 13
Consolidate different worksheets into one worksheet 4
Consolidate tables/ranges with text from multiple worksheets 1
consolidate data in pivot table 1
How to look up and pull text from another wkst 1
Sorting in multiple worksheets 1

Top