Turn on the macro recorder and go to the Company Info sheet. Then do
Edit=Find and enter the company name.

After it finds the company name, then turn off the macro recorder. You can
now generalize the code to pass it the name of a company to find and remove
the select and activate commands so you get a reference to the found cell.
Now you can use that with Offset to retrieve the information you need.

--
Regards,
Tom Ogilvy


slideman wrote in message
...
Hey,
I made an invoice system that generate invoices.
I did it in excel, and now I want to do it as macro.
So far it going good to me, but I have problem.
I have a sheet that his name is "Comapny Info".
I need that when I put the name of the company in the cell, it will get
details from the sheet.
I need it to work like Vlookup, but not with the Vlookup function.
Give an exmple:
Col A is company name - That I want to find.
after i find to name i want to take from col B and Col C the contact
name and from col B and phone from Col C.

Thanks for your help,
SlideMan.


---
Message posted from http://www.ExcelForum.com/