Macro for Special Copy Paste Format

[buhay]

Does anyone know a macro that copy the columns A and B from sheet 1 (which are not fixed) and paste it to sheet 2so that the result looks like below.

The macro is supposed to copy and paste ABC from sheet 1 to sheet 2. ABC should be paste on sheet 2 colA but below the last filled row(number of rows is not fixed and change from time to

time). EFG on col B should be pasted to sheet 2 colB and be located below on the left next to the last filled of colC. The number of CHF on sheet2 colD should be same as the final total

number of filled rows.




Many thanks in advance


Sheet 1

------colA-------colB

row1---ABC-------EFG

row2---ABC-------EFG

row3---ABC-------EFG


Sheet 2

------colA------colB------colC------colD

row1---EFD----------------XYZ-------CHF

row2---EFD----------------XYZ-------CHF

row3---EFD----------------XYZ-------CHF


Sheet 2 result

------colA------colB------colC------colD

row1---EFD----------------XYZ-------CHF

row2---EFD----------------XYZ-------CHF

row3---EFD----------------XYZ-------CHF

row4---ABC-------EFG----------------CHF

row4---ABC-------EFG----------------CHF

row6---ABC-------EFG----------------CHF

[buhay]

Sombody please delete this thread. It's supposed to be in the excel forum.