The following code seems to be working but instead of inserting and pasting the values from the copied range it only inserts one empty row.
The way it should work is that from the active workbook, the macro would allow you to find and select the source workbook, copy range "A4:H" & Last Row -1 from a sheet called "Summary", then on the active (destination workbook), into sheet "Contract Value", between Column A row with "1" and Column A row with "Last" insert the required rows and paste the values.
Bookmarks