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.....