smippen
New member
- Joined
- Apr 10, 2020
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2016
I am trying to match accounts number from different sheets and once the data is match, move the corresponding 4 columns to the matching account number.
I need a formula to match the account numbers in column "B" of two sheets, and then move the data from 4 columns to another sheet.
Account numbers are in column "B" of both the "ENTRY SUMMARY" and "Sheet 1" sheets
Once the account numbers have been matched, move the four cells from the second photo (cells new sub - ITC? - sheet named "Sheet 1") to sheet named "ENTRY SUMMARY" to columns BX BY BZ CA
I need a formula to match the account numbers in column "B" of two sheets, and then move the data from 4 columns to another sheet.
Account numbers are in column "B" of both the "ENTRY SUMMARY" and "Sheet 1" sheets
Once the account numbers have been matched, move the four cells from the second photo (cells new sub - ITC? - sheet named "Sheet 1") to sheet named "ENTRY SUMMARY" to columns BX BY BZ CA