good morning.

I don't have tons of experience using excel, mostly matlab, mathematics, and R. However I would like to get started on a problem that I am trying to solve in excel. I have a pivot table that is displaying an item related data - item id, these item id's are used to create a form, right now I am randomizing them, so every time I hit the refresh button (added manually) my item id column is updated, and new items are selected for form generation.

I would like a way to add input boxes to my pivot table, so a user can use inputs to filter the pivot table data, I would like the following filter input boxes (item id - a range of Id's can be passed in this box, and items in the pivot table refresh accordingly)

IN - this is a state standard the user can input state standards, so only items from those state standards are displayed.

DOK - this is item difficulty, a button or input box can be used to select items from difficulty 1, 2, or 3

Item type - same idea for item type

I am attaching a screenshot, but I an new to this so I might be missing details / information. please let me know what else is needed. I am not even sure of something like this is possible in excel, but maybe worth a try

Thank you so much

item form generator

0 Answers