Search function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi guys.

iam trying to create a formula that allowds to write a word in a cell ( a1)
and sends me to the specifc arrow where the word can be found. Imagine that i
write Abn Amro on the cell and it sends me to the place where that name or
word can be found 9 (a89 for example)

Many thanks !!!!
 
well iam trying to create a more acessible data base for others to use. they
will not remenber to do that so i tried to create a Search data field in one
cell but couldn´t managed it. Help me with this mate! ty Again
 
Well, I don't know of a function that will do what you're looking to do, but
why not record a macro that opens up the Find dialog box (the window you get
when you hit CTRL-F) and assign that macro to a button which you place at the
top of the screen?

Alternatively you could create a user defined function but I'm not sure what
the code for that would be.

Sorry I can't be of more help.

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top