Good Evening,
I have a cell with a data validation list of 100 suppliers, selecting a supplier populates the spreadsheet with the relevant data.

Is it possible to cycle through the supplier first to last printing the worksheet using a macro?

Rik