Macro for pulling data rows
Hi everyone! This is probably the first post of many to come so here goes:
Little about myself, I've just got a new job as a data analyst and I don't know how I managed it! I'm okay with the basics of excel however I've been trying to create some pretty complicated stuff and I'm way out of my league right now.
Basically, we are generating a report for other team members to work off, and at the moment they are applying filters by themselves to get the correct information.
Each row contains details about one particular job, and one thing to bear in mind is that there are literally thousands of these rows.
I've used COUNTIFS, VLOOKUP and other basic excel functions to create a summary of "jobs" that are past their deadline, how long past their deadline they are, and who is responsible for that job.
I want to create macros that when they click on the "summary" cell it will bring up the "jobs" rows that the cell data represents.
I managed to create a simple macro using the macro recorder that applied the necessary filters on to the data to bring up only jobs that each person was responsible for, however I could not figure out how to apply the COUNTIFS section to only get jobs that had been outstanding for a certain amount of time.
Also worth noting is that although I could create macros for each person who had jobs, there are over 70 people and over 4 different filter variations so it would need 280 macros which even when copying and pasting the macro in the VBA builder would be very time consuming, and I'm almost certain there must be a better way than this.
I've blotted the names out just to be nice as I don't know if these people would like me posting their names and how many jobs they're behind on :p
This photo is the current summary section, ideally I'd like it so if you pressed the number in the table it would pull up the jobs that the number represents. I know it must be possible however my limited excel and general programming knowledge is letting me down :(. I'd vastly appreciate any help.
If anyone would like to help but needs more information feel free to ask and i'll gladly provide it.