I have a workbook with two spreadsheets. Sheet 1 is "working data" and sheet 2 is "Solution" As the title suggests, in sheet 1 is where all my calculations are performed, then it is pasted into sheet 2 and formatted. My issue is I need the information from "working data" to be copied and pasted into "Solution" but the information from "working data" will have a variable amount of rows (currently there are over 10,000, but their could be a few thousand more in any given month. The copied range from "working data" will always start in cell A1 and then should select all rows down until it finds a cell in column A empty, then the data should be pasted into "Solution" starting with cell A40. Any help will be greatly appreciated.