Attached I have my document that I am trying to create a search engine for. I want to be able to search for a name within many location tabs. I want to be able to search by name only, bring over the information, and be able to jump to the persons name. If at all possible i would like to be able to search for all that have been billed but not paid. Any suggestions?FluClinicBilling.xlsmFluClinicBilling.xlsm
Thanks,
Kally Sue
Since it appears your sheet tabs are named exactly for the locations you wish to bring a value back from, and the values are in the same location on every sheet that exists:
D2: =INDIRECT("'" & $C2 & "'!D4")
F2: =INDIRECT("'" & $C2 & "'!J4")
G2: =INDIRECT("'" & $C2 & "'!K4")
Copy down. The sheets that don't exist or the spelling is off will give an error result.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks