JaimeMabini
New Member
- Joined
- Dec 29, 2021
- Messages
- 14
- Office Version
- 365
- Platform
- Windows
Hello,
I am new on creating Excel VBA, any assistance would be highly appreciated.
I am trying to create a VBA that will read the entire Sheet1 and find matches in sheet2. If the value in sheet1 matches a value in sheet2 in any row order, copy the and replace the row found in sheet2 with the value from sheet1.
Example of what I am trying to do (note that the sheet contains massive data with formula on some cells)
Sheet1:
Sheet2:
After running the VBA Code:
Sheet2:
Result is that Row1 and Row3 in sheet1 is found in sheet2, and therefore after running the code sheet2 will be updated with the value found in sheet1
I am new on creating Excel VBA, any assistance would be highly appreciated.
I am trying to create a VBA that will read the entire Sheet1 and find matches in sheet2. If the value in sheet1 matches a value in sheet2 in any row order, copy the and replace the row found in sheet2 with the value from sheet1.
Example of what I am trying to do (note that the sheet contains massive data with formula on some cells)
Sheet1:
Row1 | mm | Value1 |
Row2 | mm | Value2 |
Row3 | mm | Value3 |
Sheet2:
Row4 | mm | Value4 |
Row1 | mm | Value5 |
Row5 | mm | Value6 |
Row3 | mm | Value7 |
After running the VBA Code:
Sheet2:
Row4 | mm | Value4 |
Row1 | mm | Value1 |
Row5 | mm | Value6 |
Row3 | mm | Value3 |
Result is that Row1 and Row3 in sheet1 is found in sheet2, and therefore after running the code sheet2 will be updated with the value found in sheet1