How To: Extract data from Worksheet Tab

[Otter]

Howdy folks,
I've got a timesheet that was supplied to me at work here that I have to
submit once a week with a breakdown of hours spent on various projects.
What I have done up until now is identify each tab on each of the worksheets
with the date of the timesheet that will be submitted. IE: Aug 2, Jul 12,
Jun 21, etc. What I would like to do is have that data referenced in a cell
within the worksheet itself. THAT data will then be used to populate other
cells with date data. I've tried looking in help for information regarding
ActiveSheet.Name, hoping that could lead me on to bigger and better things,
but no luck. Can anyone help ? Muchos gracias.

Otter

 

[Frank Kabel]

Hi
have a look at the INDIRECT function

 

[hgrove]

Otter wrote...

I've got a timesheet that was supplied to me at work here that ...
. . . What I would like to do is have that data referenced in a cell
within the worksheet itself. THAT data will then be used to
populate other cells with date data. . . .

...

Naming a worksheet acording to a cell entry requires VBA. Do you hav
authority to write macros for this workbook you've been given?

Since you need to enter the date somewhere, why not enter it as th
worksheet name in the worksheet tab? If the workbook has already bee
saved to disk, you can then access the worksheet name using th
formula

=MID(CELL("Filename",INDIRECT("A1")),
FIND("]",CELL("Filename",INDIRECT("A1")))+1,32)

and you could convert it to a date value using the formula

=--MID(CELL("Filename",INDIRECT("A1")),
FIND("]",CELL("Filename",INDIRECT("A1")))+1,32)

Make that last formula a defined name (Insert > Name > Define), and yo
could use that defined name in the worksheet whereever you want the dat
value. That doesn't require VBA

 

[Otter]

Well, I feel like a total prat, but I can't find the way that this is
supposed to help. I am under the impression that INDIRECT would help with
cell referencing, but not with Worksheet or Workbook referencing. Am I
missing something blatant because of Monday morning bleariness ? Thanks
Frank.

Otter