Hi all ,
I have a workbook with about 20 to 50 sheets.
Inside the workbook has a worksheet, named Summary, which will help to summarize up all the worksheet.
I would like to create a table with the following info extract from each sheet.
Column 1 : Tabname of each worksheet except Summary
Column 2 : Return a count on how many "completed" are found in column H in every sheet except for the Summary worksheet.
For column 3 : I would like to have a link to navigate to the respective worksheet.
I have a workbook with about 20 to 50 sheets.
Inside the workbook has a worksheet, named Summary, which will help to summarize up all the worksheet.
I would like to create a table with the following info extract from each sheet.
Column 1 : Tabname of each worksheet except Summary
Column 2 : Return a count on how many "completed" are found in column H in every sheet except for the Summary worksheet.
For column 3 : I would like to have a link to navigate to the respective worksheet.
Last edited: