Solved: Multiple Tab Data to Chart

[Shazam]

Hi hobs31,

Based on your example, See if this method would help.

First you'll need to list your worksheets. Go to the Define name range and input this in the define box.

Name: Sheets

Refer to: =SUBSTITUTE(GET.WORKBOOK(1),"["&GET.WORKBOOK(16)&"]","")&T(NOW())

Input formula in cell D3 and copy down.

=INDEX(Sheets,ROWS($D$3:D3))

Then input formula in cell C3 and copy down.

=INDIRECT("'"&D3&"'!C8")


Now for the chart to have it dynamically. Input these formulas in the Define name range as well.

Name: Range

Refer to: ='Yield Data'!$C$3:INDEX('Yield Data'!$C$3:$C$65536,MATCH(2,1/('Yield Data'!$C$3:$C$65536>0)))

Name: Range1

Refer to: ='Yield Data'!$A$3:INDEX('Yield Data'!$A$3:$A$65536,MATCH(2,1/('Yield Data'!$A$3:$A$65536>0)))

I left the example in your workbook below.


Hope it helps!