I have attached a sample file with a few lines of data just to show what I am talking about.
I have a large list of preset variables which the user will select with an ever reducing list to choose from which builds a statement . This statement is then pasted into another sheet.
Currently I use a table and associated pivot table with the use of slicers to give me the result I am looking for. Kind of like a predictive text and sentence generator, except really dumb and crude but specific to my needs.
This is how I start the routine
Clear all slicers
Then using the slicers, I select the state
then select the City
then the object
then the action.
As I do this the selections build my output (statement) into cell M1.
I then run code vba to paste the value in Cell "F3" into another worksheet with a time stamp. I then reset the slicers to allow the next statement to be built.
I guess what I would like to know if there is an easier way to do this which is just as visually pleasing as the Pivot table slicers???? Any hints on how its been done in the past? Better faster ways?
Eventually I will have a userform rather than how it looks currently.
Thanks in advance for the forthcoming help.
Disclaimer: I know the list of states and cities is not complete but its just a sample set of data.
edit: Maybe there is a VBA solution with the use of userforms that acts like pivot table slicers.
Bookmarks