print all using macro

[luvbite38]

Hi Guys,

I have a dashboard which allows user to view KPI.

On this page, user can select items in cell A2 and all the charts and tables automatically changes based on the selection.

Cell A2 is a Data Validation List and has over 300 items to select for.

Is there a possibility, I run a macro which select each item in A2, refresh the calcs and print out the page in pdf.

I want this loop to finish when the seletion in A2 is blank?

I am not sure, if this can be done?

Please help

LB