Hi All,
I currently use workbook to manage my purchase orders at work. It's made up of a "Start" sheet, the "Template" and followed by all my orders. When orders are invoiced, I hide the sheet.
My start sheet is just a button (that duplicates the template, numbers the sheet, etc)
The template is self explanatory
What I'm trying to do is make a list on my start sheet showing all the visible sheets (minus sheets 1 and 2 (start and template) - essentially my "current open orders".
In the adjacent cell to each number, I'd also like the customer name, which can be easily taken from cell A9 within each order sheet
Also, if it's do-able, each number to be a hyperlink to that specific sheet
I'm assuming this would be done on sheet start-up, so possibly needs clearing before listing again?
This would make it really easy for me to see all the current orders when the sheet is loaded
Many thanks in advance.
I currently use workbook to manage my purchase orders at work. It's made up of a "Start" sheet, the "Template" and followed by all my orders. When orders are invoiced, I hide the sheet.
My start sheet is just a button (that duplicates the template, numbers the sheet, etc)
The template is self explanatory
What I'm trying to do is make a list on my start sheet showing all the visible sheets (minus sheets 1 and 2 (start and template) - essentially my "current open orders".
In the adjacent cell to each number, I'd also like the customer name, which can be easily taken from cell A9 within each order sheet
Also, if it's do-able, each number to be a hyperlink to that specific sheet
I'm assuming this would be done on sheet start-up, so possibly needs clearing before listing again?
This would make it really easy for me to see all the current orders when the sheet is loaded
Many thanks in advance.