I am at a lost. I work in a call center where only the managers, reports analysts, and up have excel. I came up with a great idea to pull in the stats for the phone reps on a daily basis that they would be able to on to see if they are trending up or down so they would be able to manage their goals. These phone reps only have excel viewer, and to my knowledge they can look at the spreadsheet but they can't select from a combobox, type into a combobox, or select from a data validation list.
So my question is how can I take a spreadsheet that requires the user to select their EE# from a combo box that then vlookups/indirects stats from another tab without them having excel? I have researched almost everything I can think of. We have a proxy that blocks google, but I tried google docs, Zoho, Xcelcius (didn't want to import my excel model(s). I am wondering if there is a way I can mix HTML with Excel that is interactive that would allow them to select an HTML drop down that would then populate data.![]()
![]()
Any and all help would be greatly appreciated!
Bookmarks