Use Tab Name as Value

R

Rob

What I want to do is have the worksheet tab name translate to appropiate row
on the ChartsData worksheet dynamically instead of me having to place a huge
bunch of mods for each chart number, (right now I'm up to 132).

Worksheet Names:
Sheet 1 == Chart0001
Sheet 2 == Chart0002 etc...

=OFFSET(ChartsData!ChartStatTitles,1,0)

ChartsData!ChartStatTitles == "=ChartsData!$B$1:$G$1"

Cell A1 == "Chart #s"
$A$2 == Chart0001
$A$3 == Chart0002 etc...


I was thinking of something like "indirect" but I can't seem to quite figure
it out.

=OFFSET(ChartsData!ChartStatTitles,ROWS(INDIRECT(SheetName)),0)


Any help would be great.

Thanks in advance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help on vba macro to put multiple charts on multiple worksheets based on table in each worksheet 0
Charting macro for creating multiple charts on multiple sheets 0
COUNTIF + ADDRESS Issue 1
Copying Named Ranges in Chart Series 1
How to display the Chart Name as a Chart Title? 1
Impossible? Not plotting NA()s 2
Worksheet tab names change back to default 0
Chart worksheet names keep resetting 0

Top