Ok, I'm gonna write down what I'm trying to do, then please suggest what option is best for me (as well as if you know of the ExcelIsFun Youtube videos that you'd recommend for me to do this!)
1. I have zero knowledge of how Access works, so excel is best for me.
2. I have a static excel data set that I never need to update (Employee, Manager, 4 topics, comment, date)
3. I need to create a query (such as manager, topic, and timeframe) available to any user, where once submitted, will display the data on a chart or pivot table.
4. I need to get this done in 1 week. Is this even possible?!!?! I really need help from the ExcelIsFun videos because the ones I have seen are the only ones I seem to understand... but there are like 1500 videos!
============
So, as the user (I know I'll probably need VBS),
1. The user would be able to simply click on dropdowns to select form queries such as: all agents, topic of tardiness, within last 3 months
2. Then the next page will display a pivot table
3. Upon clicking the case number, the user can then view details of that entry.
1. I have zero knowledge of how Access works, so excel is best for me.
2. I have a static excel data set that I never need to update (Employee, Manager, 4 topics, comment, date)
3. I need to create a query (such as manager, topic, and timeframe) available to any user, where once submitted, will display the data on a chart or pivot table.
4. I need to get this done in 1 week. Is this even possible?!!?! I really need help from the ExcelIsFun videos because the ones I have seen are the only ones I seem to understand... but there are like 1500 videos!
============
So, as the user (I know I'll probably need VBS),
1. The user would be able to simply click on dropdowns to select form queries such as: all agents, topic of tardiness, within last 3 months
2. Then the next page will display a pivot table
3. Upon clicking the case number, the user can then view details of that entry.
Last edited:
