Hello everyone,

I am trying to build an automatic reporting tool
I have a data validation list in the report which drives some formulas.
I would like to also link the selection of the data validation to an autofilter on the raw data (graph of teh raw data would then also be driven by the data validation selection)

I have been using this following code (embedded in "RAW" data sheet) and a random cell (B1) to the data validation selection.
My problem is that it doesn't automatically update, I have to select the sheet for it to work

Please Login or Register  to view this content.
is there any way to link it directly to the data validation list so that the autofilter updates everytime the data validation selection is changed (in cell C3)


Thanks