A client of mine uses excel all the time, I have generated an excel workbook for them, as they like the reports they can generate using excel.

The data is squirted to a workbook, which contains 32 sheets, the first 31 sheets are named day 1 to day 31….as in each day of a month, the 32nd is a summery of all the sheets.

My client would like to click on a cell in that row (row 12 is day 10, as the first 2 rows are for headers) in the summery report, when they do so, it will take them to that day sheet, and become the active sheet Can this be done? If not, they will have to click on the tab on the bottom, but I am in hope it can be done.

TIA