I searched for my topic and nothing matched my questions:
I have 2 worksheets, within one workbook
sheet1 is a list of EE's who took the test either, failed, passed, or incomplete
sheet2 is a list of ALL employees who SHOULD HAVE taken the test
I need to determine:
Failed, incomplete and who did not show up
The data is raw and the fields do not match. Meaning one sheet has last name, first name in one field or vice versa. Also some people used their middle initial one one sheet and did not on the other sheet. So I know some manual eyeballing is going to be required.
I found VBA code that would perform most of the work, however I do not know VBA and the instructions are not basic enough. I know how to open VBA, insert module, copy and paste the code, open macros and run. Literally that's it. I'm missing a whole bunch of stuff in between. Such as:
1. in the code, where do I tailor the cells and names so the code can read my worksheets and workbook?
2. am I suppose to open VBA in another worksheet or a new workbook?
3. I think I read when VBA is run correctly my results will download to a new workbook
So just giving you an idea of what instructions I need. I am pretty sure I have the right VBA code.
Thank ya much!
Bookmarks