I have a workbook called ReportMonth with two sheets. The Master sheet has 40 columns of data. The number of row changes every month. First 8 rows are Header rows and need not be copied.
Every month a need to generate the Report sheet that takes data from 22 columns (not continuous) of Master and must repeat for the number of rows in the Master sheet (except the header rows - or from row 9 all the way to the last row).
In the Report sheet, in row 8 I have put formulas in each column pointing to the column in Master sheet. Basically, I want Row 8 of the Report sheet to be copied down for N number of rows where N is the last row of Master sheet. Once it is done, I would like the the code to copy A8 to the last cell in Report sheet and PasteSpecial (Values and number format) to Report2024 Sheet in another Workbook called ConsolidatedReport.xlsx
Is there a simple code for this?
Many thanks.
Every month a need to generate the Report sheet that takes data from 22 columns (not continuous) of Master and must repeat for the number of rows in the Master sheet (except the header rows - or from row 9 all the way to the last row).
In the Report sheet, in row 8 I have put formulas in each column pointing to the column in Master sheet. Basically, I want Row 8 of the Report sheet to be copied down for N number of rows where N is the last row of Master sheet. Once it is done, I would like the the code to copy A8 to the last cell in Report sheet and PasteSpecial (Values and number format) to Report2024 Sheet in another Workbook called ConsolidatedReport.xlsx
Is there a simple code for this?
Many thanks.
