lpchretien
New Member
- Joined
- Jun 17, 2023
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
Hello,
I have two spreadsheets named New.xlsx and Old.xlsx. I'm looking for a VBA code that compare each column T values (unique ID) in New.xlsx with values in column T (unique ID) in Old.xlsx. When there is a match, it then copy the value and cell format (e.g. cell color) of the cell in column A of the Old.xlsx to the cell in column A in New.xlsx.
I found out this thread (VBA To find match of cell value and copy adjacent cell when match found) which work fine with 2 different Sheets in the same Excel document and to copy only cell value, but I have some difficulty to use it with 2 differents Excel files and to copy cell format.
Thanks for your help
I have two spreadsheets named New.xlsx and Old.xlsx. I'm looking for a VBA code that compare each column T values (unique ID) in New.xlsx with values in column T (unique ID) in Old.xlsx. When there is a match, it then copy the value and cell format (e.g. cell color) of the cell in column A of the Old.xlsx to the cell in column A in New.xlsx.
I found out this thread (VBA To find match of cell value and copy adjacent cell when match found) which work fine with 2 different Sheets in the same Excel document and to copy only cell value, but I have some difficulty to use it with 2 differents Excel files and to copy cell format.
Thanks for your help