IreneSimmonds
New Member
- Joined
- Nov 30, 2018
- Messages
- 1
I am very new to using Excel and macro, please be gentle.
I have a spreadsheet of people sent a mail out, with each person identified by a unique number. The column headers are unique number, name, address, postcode.
I have a second sheet of people who responded, containing only their unique identification number.
I want to remove the people in the second sheet from the first sheet, so that I can send a reminder letter.
How would I do this? I'm not asking anyone to write my code, just suggest what tools I could use to do this, so I can learn for myself. I don't want to delete the rows manually and I'm sure it must be possible to automate this, I just don't know how.
Thank you!
I have a spreadsheet of people sent a mail out, with each person identified by a unique number. The column headers are unique number, name, address, postcode.
I have a second sheet of people who responded, containing only their unique identification number.
I want to remove the people in the second sheet from the first sheet, so that I can send a reminder letter.
How would I do this? I'm not asking anyone to write my code, just suggest what tools I could use to do this, so I can learn for myself. I don't want to delete the rows manually and I'm sure it must be possible to automate this, I just don't know how.
Thank you!