I have an excel datasheet that lists all of various training tests employees have taken. I need to be able to list the required tests and see if they have been passed for each employee. I need something more than an auto filter.
I have an excel datasheet that lists all of various training tests employees have taken. I need to be able to list the required tests and see if they have been passed for each employee. I need something more than an auto filter.
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Here is my demo workbook. It only has a few records whereas my live book utilizes thousands of rows.
Your profile indicates 2007, so I have saved your file as .xlsx - it contains formulas that are not compatible with 2003, so let me know if you need this to work in that version...
Ill check it out when I get home this evening.
I meant to mention, on Report in column I, I pull out unique names, which I then use for the DD on A1. All my formulas only go down to row 30, so you will need to adjust accordingly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks