I would like VBA code to copy the following columns from one workbook and to paste them into specified columns. The data in the destination workbook must be copied below the last data that appears in thiscworkbook. for eg if theere is data in A40, it must be copied to A41
Source Work book
1) Col A from row 5 onwards, ** followed by tesxt as well as text "Report by*.*" to be ignored when copying data -this must be copied in the destination workbook in Col C in the row after the last data
2) Col N from row 5 onwards -this must be copied in the destination workbook in Col I in the row after the last data
3) Col M from row 5 onwards -this must be copied in the destination workbook in Col K in the row after the last data
4) Col H from row 5 onwards -this must be copied in the destination workbook in Col L in the row after the last data
Your assistance in this regard is most appreciated
Source Work book
1) Col A from row 5 onwards, ** followed by tesxt as well as text "Report by*.*" to be ignored when copying data -this must be copied in the destination workbook in Col C in the row after the last data
2) Col N from row 5 onwards -this must be copied in the destination workbook in Col I in the row after the last data
3) Col M from row 5 onwards -this must be copied in the destination workbook in Col K in the row after the last data
4) Col H from row 5 onwards -this must be copied in the destination workbook in Col L in the row after the last data
Your assistance in this regard is most appreciated
