keilah
08-22-2007, 01:13 AM
Hi
Need help with a macro that will copy and paste all data from one workbook "Monthly Income Report"
data range: row 1 col A (start) to col N for all row down say to 500.
and paste this into a second workbook "RevalComparisonModel"
data range: row 5 col A (start) to col N (all the way down in rows to match data from first workbook). - macro button to be placed in second workbook.
the number of columns remains fixed cannot change always A to N......and the start of each row has to be:
row 1 - firstworkbook and row 5 second workbook.
thanks.......for all your help/feedback developers.....
Need help with a macro that will copy and paste all data from one workbook "Monthly Income Report"
data range: row 1 col A (start) to col N for all row down say to 500.
and paste this into a second workbook "RevalComparisonModel"
data range: row 5 col A (start) to col N (all the way down in rows to match data from first workbook). - macro button to be placed in second workbook.
the number of columns remains fixed cannot change always A to N......and the start of each row has to be:
row 1 - firstworkbook and row 5 second workbook.
thanks.......for all your help/feedback developers.....