Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Consolidate Worksheet Contents
Greetings to All!
I have a workbook with say 8 to 9 worksheets each containing multiple columns not arranged the sequencially. For Eg Sheet 1 has the following Column Headers: COMPOUND DESCRP LOOPID MEAS HSCI1 LSCI1 Sheet 2: COMPOUND NAME DESCRP PERIOD PHASE LOOPID Sheet 3: DESCRP PERIOD PHASE LOOPID SIMOPT and so on... Now I want to consolidate all the contents of Worksheets under a Single TAB, how do I go about it? Is there a macro Readily available? On searching the forums I found a similar problem addressed by Mr. Bernie Deitrick. But that didn't serve my purpose as it had a restriction of only 3 columns :( Thanks a lot in anticipation ;) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I consolidate multiple worksheet files into one workbook | Excel Discussion (Misc queries) | |||
Consolidate different worksheets into one worksheet | Excel Discussion (Misc queries) | |||
Consolidate multiple workbooks into a single worksheet | Excel Worksheet Functions | |||
Can't Edit Contents of Protected Worksheet | Excel Discussion (Misc queries) | |||
Listing Directory Contents in Worksheet | Excel Discussion (Misc queries) |