LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Consolidate data from multiple worksheets into one bartonHR Excel Discussion (Misc queries) 2 October 26th 07 05:04 PM
I need to consolidate data from 3 different worksheets? CG Excel Worksheet Functions 1 December 12th 05 01:04 AM
'Consolidate' data from multiple worksheets spliknik Excel Discussion (Misc queries) 4 November 3rd 05 01:32 PM
How to consolidate data from multiple worksheets. SAR Excel Worksheet Functions 0 August 28th 05 12:56 PM
Consolidate data from several worksheets via pivottable mthatt Excel Worksheet Functions 0 March 23rd 05 05:35 PM


All times are GMT +1. The time now is 11:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"