I was wondering if it was possible to create a macro that only pastes data from specific cells from clipboard to the same cells in another table. For example, if I wanted to update the data in a table from another table using the same cells specifically A2:A3 and A7:V5000. I know you can copy and paste sheets using specific file names but one of the tables is exported from another program that populates a new name for the file with a different ID number. I know I can just copy and paste the table into the sheet but I also have a couple of other macros and hidden columns on the sheet that I don't want to mess up.