| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merge Append all sheet
''''''''Hello guys please help me to get result sheet as shown in follows
''''''''''''please help me to find the result as shown as folliows 'Sheet1 Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7 a1 b1 c1 a2 b2 c2 a3 b3 c3 a4 b4 c4 a5 b5 c5 a6 b6 c6 a7 b7 c7 a8 b8 c8 a9 b9 c9 a10 b10 c10 a11 b11 c11 a12 b12 c12 a13 b13 c13 a14 b14 c14 a15 b15 c15 a16 b16 c16 a17 b17 c17 'Sheet2 Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7 a1 b1 c1 a2 b2 c2 d2 a3 b3 c3 a4 b4 c4 a5 b5 c5 a6 b6 c6 d6 a7 b7 c7 a8 b8 c8 a9 b9 c9 a10 b10 c10 a11 b11 c11 d11 a12 b12 c12 a13 b13 c13 a14 b14 c14 a15 b15 c15 a16 b16 c16 a17 b17 c17 d17 'Sheet3 Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7 a1 b1 c1 d1 e1 a2 b2 c2 e2 a3 b3 c3 d3 e3 a4 b4 c4 a5 b5 c5 d5 a6 b6 c6 e6 a7 b7 c7 d7 e7 a8 b8 c8 a9 b9 c9 a10 b10 c10 d10 e10 a11 b11 c11 a12 b12 c12 d12 a13 b13 c13 d13 e13 a14 b14 c14 a15 b15 c15 a16 b16 c16 d16 e16 a17 b17 c17 'RESULT_SHEET Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7 a1 b1 c1 d1 e1 a2 b2 c2 d2 e2 a3 b3 c3 d3 e3 a4 b4 c4 a5 b5 c5 d5 a6 b6 c6 d6 e6 a7 b7 c7 d7 e7 a8 b8 c8 a9 b9 c9 a10 b10 c10 d10 e10 a11 b11 c11 d11 a12 b12 c12 d12 a13 b13 c13 d13 e13 a14 b14 c14 a15 b15 c15 a16 b16 c16 d16 e16 a17 b17 c17 d17 -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I append 20 worksheets in single sheet. | Excel Worksheet Functions | |||
| How do I match and append/merge data from two spreadsheets? | Excel Discussion (Misc queries) | |||
| How to Append data in excel sheet | Excel Programming | |||
| Append info in all worksheets in workbook in one sheet | Excel Programming | |||
| Append instead of Replace in Merge Workbook? | Excel Worksheet Functions | |||
Threaded Mode
