I have to prepare 70+ tables from a data set. In order to take the same information from the data set, I have created a validation list dropdown (in cell A2). The next step (that I need help with) is recording a macro that prints the first table, then selects the next item on the list and prints that table, continuing until all 70 table are printed.
I tried to record the macro, but the macro won't select the following item on the list before printing. Does anyone know how to edit the macro to do this?
Thank you for your help!
I tried to record the macro, but the macro won't select the following item on the list before printing. Does anyone know how to edit the macro to do this?
Thank you for your help!