cashew1970
Board Regular
- Joined
- Feb 28, 2005
- Messages
- 57
Hello All,,
I have a workbook that contains 2 sheets
Sheet1 contains data of accounts active on a system, and A1 has the account numbers in
Sheet2 contains info of people who have paid for accounts and B1 has the acount numbers in
I am looking to highlight all of the accounts in Sheet 2 that do not appear in sheet1 so that we can identify all of the accounts that have not registered but are still paying for a service
I have tried Vlookup, but appear to be failing! and I really do not like Outlook 2007!!
Regards
Martin
I have a workbook that contains 2 sheets
Sheet1 contains data of accounts active on a system, and A1 has the account numbers in
Sheet2 contains info of people who have paid for accounts and B1 has the acount numbers in
I am looking to highlight all of the accounts in Sheet 2 that do not appear in sheet1 so that we can identify all of the accounts that have not registered but are still paying for a service
I have tried Vlookup, but appear to be failing! and I really do not like Outlook 2007!!
Regards
Martin