MRichmond
01-25-2012, 04:42 AM
Good day to everyone.
A two part challange today.
I have a workbook with a number of worksheets, the majority of which will have data in them relating to audits conducted. the number and name of the sheets will change over time.
I have code that activates when the Summary Sheet is selected that gets a list of all the sheets in the workbook and creates a list on this sheet.
So far so good
First challenge,
There are a number of tabs that I dont wish to be in this list on the summary tab, but they do have to be in the workbook. The sheets to be exluded are listed on a hidden sheet ("Lists"), in a named range "Exclude".
How can I exclude theses sheets from my list on the summary tab.
Second challenge,
For each of the sheets that make it onto the summary tab list, in column B I need the audit result. This will always come from the same place on the audit sheets (in the test case it is cell "I2"). How do I combine a sheet name (which will change) with the cell reference (which will always be the same), to give me what I am looking for (see example sheet "Summary Two").
Thanks in advance for your help
A two part challange today.
I have a workbook with a number of worksheets, the majority of which will have data in them relating to audits conducted. the number and name of the sheets will change over time.
I have code that activates when the Summary Sheet is selected that gets a list of all the sheets in the workbook and creates a list on this sheet.
So far so good
First challenge,
There are a number of tabs that I dont wish to be in this list on the summary tab, but they do have to be in the workbook. The sheets to be exluded are listed on a hidden sheet ("Lists"), in a named range "Exclude".
How can I exclude theses sheets from my list on the summary tab.
Second challenge,
For each of the sheets that make it onto the summary tab list, in column B I need the audit result. This will always come from the same place on the audit sheets (in the test case it is cell "I2"). How do I combine a sheet name (which will change) with the cell reference (which will always be the same), to give me what I am looking for (see example sheet "Summary Two").
Thanks in advance for your help