| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Consolidate data from multiple worksheets into one | Excel Discussion (Misc queries) | |||
| I need to consolidate data from 3 different worksheets? | Excel Worksheet Functions | |||
| 'Consolidate' data from multiple worksheets | Excel Discussion (Misc queries) | |||
| How to consolidate data from multiple worksheets. | Excel Worksheet Functions | |||
| Consolidate data from several worksheets via pivottable | Excel Worksheet Functions | |||
Linear Mode
