How best to do the followin

  • Thread starter Thread starter Dave
  • Start date Start date
D

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
 
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,

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,

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 -
Click to expand...

thanks I did post it in the Excle group just fat fingered it.
 
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 -
Click to expand...

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