D
Dave
I have a spreadsheet called COMPINFO that has tabs for the 12 months
named as JAN09,FEB09,MAR09,APR09,MAY09, JUNE09 and so on. They are
created at the end of the month so end of May I will have May09. In
each of these tabs there is a company code in cell A3 to A150. This
company code uniquely identifies a company. These codes once
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 in an another tab in COMPINFO .
This tab is called DND . 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 excel to
lookup its value in DND & return the company name in this case Big
Bass Outfitters and add it as a comment on the cell in which 0010-BBBB
is stored and if they click in the cell containing 0010-CCCC I want to
excel to lookup the code in DND and display its company name Canada
Water and add it as a comment to the cell that contains 0010-CCCC and
so on and so forth
Another way could be that the I could create a button and fire a macro
to insert the comments on all named tabs except DND in COMPINFO
All suggestions are welcome.
,
Thanks,
named as JAN09,FEB09,MAR09,APR09,MAY09, JUNE09 and so on. They are
created at the end of the month so end of May I will have May09. In
each of these tabs there is a company code in cell A3 to A150. This
company code uniquely identifies a company. These codes once
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 in an another tab in COMPINFO .
This tab is called DND . 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 excel to
lookup its value in DND & return the company name in this case Big
Bass Outfitters and add it as a comment on the cell in which 0010-BBBB
is stored and if they click in the cell containing 0010-CCCC I want to
excel to lookup the code in DND and display its company name Canada
Water and add it as a comment to the cell that contains 0010-CCCC and
so on and so forth
Another way could be that the I could create a button and fire a macro
to insert the comments on all named tabs except DND in COMPINFO
All suggestions are welcome.
,
Thanks,