Hello,
I'm trying to arrange add a Macro button to my spreadsheet so that it will open up a previously saved spreadsheet, search for the project code and copy the data from certain cells and paste into the 2nd spreadsheet.
I recorded the following macro, but that limits it to a certain row...