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
Reply With Quote