View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
James James is offline
external usenet poster
 
Posts: 542
Default Worksheets in a formulae

In my workbook to work out efficiences and such I have a total of 6 sheets.
One for each day of the week and one for the oberall efficiences on the week
(based on a five day working week).

On each sheet there is four different sections that can be printed out
independantly of each other if required. Each one os theese sections require
a date.

Each worksheet is also named by the date. E.G Sheet one will be 080208,
sheet two 090208 and so on.

Is there any way that I can take the worksheet name (the date) and using a
formulae or some such to insert it into that days work sheet.

So at the beggining of the week I don't have to enter every last date
independentl??

Thanks
James