Formula containing sheet names
Hey all,
As per the attached, I have say 5 work sheets each called Abbott, Barnes, Coomes etc
I have done a formula for Abbott as shown attached however I actually have about 50 sheets with names. I have the names listed in column A. Is there a formula that instead of typing Abbott as shown I can use the cell in column A to generate a code ?
Hope I'm making sense !
Try this, based on the layout of your jpg file. Put this formula in cell B2 of your summary sheet as shown in the jpg file.
Copy to every cell down and across. This is based on the assumption that you want row 2 from all the sheets.
Please Login or Register to view this content.
Let me know if it works.
Conor
Last edited by Conor; 02-01-2008 at 05:13 PM.
Thats great - do you know if you can put INDIRECT and IF Statements together ?
My gosh I've figured it out !
=IF((INDIRECT("'"&A3&"'!B3")=0),(INDIRECT("'"&A3&"'!B39")),(INDIRECT("'"&A3&"'!B3")))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks