Good Day,
I have a workbook with about 40 sheets. The sheets are all setup the same. 7 row header with the data starting on row 8.
I would like to copy all rows (starting with row 8 and ending with the last row of data) on all contract sheets. The copied rows will be pasted in the sheet titled OPS View starting at row 8. I've found tons of code online but because of my inexperience I am unable to make them work for me. Any help is greatly appreciated.
Sample workbook is attached. The real workbook the worksheets have different names (except for OPS View.
Thank You
Bookmarks