 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008Reference value on worksheet from name in cell
I need to see if there is a way to reference a value in a worksheet that is dependent on the name of the worksheet that is in an active cell on the first worksheet. Summary Sheet is like this: A B 1 Clinic Name 2 Total number of patients 3 Carthage ='a3'!e24 4 Gallatin ='a4'!e24 ... I have many worksheets for many clinics...any ideas for simplicity? Any code to replace the reference in the b column (replace: a3, or a4 so that it would work?) TIA, Josh Try this in B3: =INDIRECT("'"&A3&"'!E24") and copy down as required. Hope this helps. Pete > I need to see if there is a way to reference a value in a worksheet > that is dependent on the name of the worksheet that is in an active [quoted text clipped - 16 lines] > > Josh > Try this in B3: > [quoted text clipped - 28 lines] > > - Show quoted text - ok, I tried that and the only problem is that the 'value' that I mentioned would be in the other sheet is actually a reference to another sheet with the data using vlookup for information from the clinic. it then returns just a blank cell. ?? -Josh I don't understand - please try to describe what you have (and what you want to achieve) more accurately. Refer to actual sheet names and ranges used etc. Pete > > Try this in B3: > [quoted text clipped - 37 lines] > > - Show quoted text - > I don't understand - please try to describe what you have (and what > you want to achieve) more accurately. Refer to actual sheet names and [quoted text clipped - 45 lines] > > - Show quoted text - Pete- Thanks for all your help. It was my mistake. I reference the wrong cell so it wasn't getting the right results. it was refrerence a blank cell on the worksheet, so it actually it worked. Thanks again! -Josh You're welcome, Josh - glad to be of help. Pete > Pete- > [quoted text clipped - 4 lines] > > -Josh |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.