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

Data consolidation 0
VBA Coding Help for Beginner 0
Help on consolidate worksheets from different workbooks into one 2
consolidate workbooks to worksheets in one workbook? 1
Consolidate work sheets 1
consolidate multiple worksheets 13
Macro to select and delete levels of a document 2
Consolidate tables/ranges with text from multiple worksheets 1

Top