PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE,

  • Thread starter Thread starter shyam
  • Start date Start date
S

shyam

''''''''''''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
 
If a1-a17 are really continuous and identical in all sheets like in your
example then enter this formula in A2 in result sheet and fill it to the
right and down:

=IF(NOT(ISBLANK(Sheet1!A2)),Sheet1!A2,IF(NOT(ISBLANK(Sheet2!A2)),Sheet2!A2,IF(NOT(ISBLANK(Sheet3!A2)),Sheet3!A2,"")))


--
Regards!
Stefi



„shyam†ezt írta:
 
Back
Top