TheBubbleUp
New Member
- Joined
- Apr 5, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I need to be able to match exact cells, and then copy all the information that is exactly 6 cells to the right, is that even possible?
The cells that need to be matched as duplicates are short strings of numbers, so it has to be an exact match. If I click find next then I get a bunch of extra matches that are not exactly the same.
Also, the sheet is broken up into several blocks of cells grouped in columns of 7: Order Number, Email, Price, First Name, Last Name, Notes, and then a blank column and then it repeats for a different date.
Sometimes on squarespace, when you export your orders, if someone orders twice then all the information except their order number shows up blank.
So I am trying to fill in the info next to the duplicate order numbers.
Any ideas?
The cells that need to be matched as duplicates are short strings of numbers, so it has to be an exact match. If I click find next then I get a bunch of extra matches that are not exactly the same.
Also, the sheet is broken up into several blocks of cells grouped in columns of 7: Order Number, Email, Price, First Name, Last Name, Notes, and then a blank column and then it repeats for a different date.
Sometimes on squarespace, when you export your orders, if someone orders twice then all the information except their order number shows up blank.
So I am trying to fill in the info next to the duplicate order numbers.
Any ideas?