How to consolidate all worksheets data into 1 worksheets?
 

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.

How to consolidate all worksheets data into 1 worksheets?
 

Please refer the below link

http://msdn.microsoft.com/en-us/library/cc793964.aspx

--
If this post helps click Yes
---------------
Jacob Skaria


"Janet L" wrote:

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.