To whom it may concern,
Hello, my name is Jake, and today I'm working with a contact spreadsheet that is beyond my current skill set. I'm looking for help in writing a macro (I think that's what's needed). The command set is as follows:
Look at columns A, B, C, D, & E (Sheet1) and determine which rows within that column range are duplicates
For the corresponding rows that are a complete match (whereas all of the cells are identically matched within that column range of A through E)
Proceed to then look at columns F through AH (within the identified, duplicate rows)
If the corresponding rows are a match, delete all redundant rows (keep one)
Then, look at Sheet 1 again. For every row that is only populated with values in columns A through E and columns H through J, split off that row to sheet 3 (beginning on row 2 of sheet 3).
Would someone be so kind as to help me with this?
Thanks in advance!
Jake
Hello, my name is Jake, and today I'm working with a contact spreadsheet that is beyond my current skill set. I'm looking for help in writing a macro (I think that's what's needed). The command set is as follows:
Look at columns A, B, C, D, & E (Sheet1) and determine which rows within that column range are duplicates
For the corresponding rows that are a complete match (whereas all of the cells are identically matched within that column range of A through E)
Proceed to then look at columns F through AH (within the identified, duplicate rows)
If the corresponding rows are a match, delete all redundant rows (keep one)
Then, look at Sheet 1 again. For every row that is only populated with values in columns A through E and columns H through J, split off that row to sheet 3 (beginning on row 2 of sheet 3).
Would someone be so kind as to help me with this?
Thanks in advance!
Jake
