How best to do the followin

[Dave]

Hi,

I have a spreadsheet that contains a company code in cell A3 to A150.
This company code uniquely identifies a company. These codes ones
assigned are not transferred to another company. What I want to do is
when a user clicks in a cell with the company code I want to reference
its company name. This way the user is not running around looking up
company names that are stored an another excel file . The company
codes are as follows:

0010-BBBB
0010-CCCC
0013-0000
0015-0100
0041-WOKS

So if a user clicks on cell a1 containing 0010-BBBB I want to return
Big Bass Outfitters and if they click in the cell contusing 0010-CCCC
I want to display Canada Water and so on and so forth

I was thinking about some how adding automatic comments by looking up
the company codes against the company name and inserting comments. But
I am not sure if its a good solution and if it can be done.

All suggestions are welcome.

Please reply here or reply to may email,

thanks,

Dave

 

[Steve Schapel]

Dave,

The focus of this newsgroup is Access, the database program. You will have
a better chance of a good answer if you re-post your question to an Excel
related group.

 

[Steve Schapel]

Dave,

The focus of this newsgroup is Access, the database program. You will have
a better chance of a good answer if you re-post your question to an Excel
related group.

 

[Dave]

Dave,

The focus of this newsgroup is Access, the database program.  You will have
a better chance of a good answer if you re-post your question to an Excel
related group.

--
Steve Schapel, Microsoft Access MVP










- Show quoted text -

thanks I did post it in the Excle group just fat fingered it.

 

[Dave]

Dave,

The focus of this newsgroup is Access, the database program.  You will have
a better chance of a good answer if you re-post your question to an Excel
related group.

--
Steve Schapel, Microsoft Access MVP










- Show quoted text -

thanks I did post it in the Excle group just fat fingered it.