Excel help needed.
 

I am wanting cell C20 to use the text in cell B20 as the name of the
worksheet to get the data from in cell Q4.

A thousand thank-yous to the first person to help.

Excel help needed.
 

Go to http://www.edferrero.com/ExcelCharts...2/Default.aspx
and find 'Report Workbook'. This used INDIRECT + ADDRESS functions to get
chart data from other workbooks.

Ed Ferrero
Microsoft Excel MVP
http://www.edferrero.com

I am wanting cell C20 to use the text in cell B20 as the name of the
worksheet to get the data from in cell Q4.

A thousand thank-yous to the first person to help.

Excel help needed.
 

=INDIRECT("'"&B20&"'!Q4")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mr QA Man" wrote in message
oups.com...
I am wanting cell C20 to use the text in cell B20 as the name of the
worksheet to get the data from in cell Q4.

A thousand thank-yous to the first person to help.