View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Boyd Parks Boyd Parks is offline
external usenet poster
 
Posts: 1
Default How can I use the value on a tab in a formula?

I am trying to create a workbook with 52 sheets, one for each week in a
year. There needs to be a column for each day of the week on each sheet. I
want the Friday's date to appear as the tab's value on each sheet. And
finally, I want to be able to use &[Tab] in the heading. Ideas?