Hello!
I have a workbook with multiple work sheets, each sheet has an unique name and the names have spaces.
I'm referencing these sheets from a summary sheet that has totals, no calculations are needed. I need help on the syntax in the following formula;
=INDIRECT($B4&"!G"&TEXT($A4,"###"))
I understand that I need Quotes...just not sure where to place them.
perhaps
=INDIRECT("'"&$B4&"'!G"&TEXT($A4,"###"))
Josie
if at first you don't succeed try doing it the way your wife told you to
I assume B4 contains the sheet name. Show us what it is.
Also, show us what's in A4. I'm gussing it's a row number.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Try this one
Please Login or Register to view this content.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks