All,
Is there a way of countins the number of sheets that have a certain name on a assigning a Page (Sheet) number to a particular cell on each.
i.e. I have 12 sheets (current) they are all called AgentA Mon, AgentB Mon, AgentC Mon etc. (the AgentA,b,c are real names of people). This is repeated for each day of the week.
What I'd like is for Excel to count the number of sheets and on AgentA put A1= "page 1" B1= "of 12".
the cells don't actually NEED the 'page' or 'of' in them.
I'd like this to be done viewing the sheets left to right in the workbook.
Also, if it's any help every day had the SAME people and ALWAY the same order.
Anyone??
Is there a way of countins the number of sheets that have a certain name on a assigning a Page (Sheet) number to a particular cell on each.
i.e. I have 12 sheets (current) they are all called AgentA Mon, AgentB Mon, AgentC Mon etc. (the AgentA,b,c are real names of people). This is repeated for each day of the week.
What I'd like is for Excel to count the number of sheets and on AgentA put A1= "page 1" B1= "of 12".
the cells don't actually NEED the 'page' or 'of' in them.
I'd like this to be done viewing the sheets left to right in the workbook.
Also, if it's any help every day had the SAME people and ALWAY the same order.
Anyone??