| 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 -- |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Merge Append all sheet
I think we ned some clarifications to get this macro correct the 1st time. 1) How do you know which rows on each sheet get combined. Is it always row 2 on each sheet that gets combined or is there a header column (ID number) that is usd to determine which rows on each sheet gets combined. 2) Are we merging the data so each row on the resulting sheet gets appended after the last column or are we using the header row (row 1) to determine which column the data goes into. 3) If there is data on more than one sheet in the same column and row is the data always the same? If not which sheet should we use on the Results sheet. -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=159158 Microsoft Office Help |
| Reply |
| 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 | |||
Hybrid Mode
