hi dave, can the user open both the workbooks(company names and workbook with company name) together or you want to keep company name workbook closed ?
On Thu, May 28, 2009 at 8:32 AM, Aindril De <aind...@gmail.com> wrote: > Hi Dave, > > I guess this will help you. > > > http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_21610927.html > > Please scroll down to the bottom to get the accepted solution. > > Regards, > Andy > > On Thu, May 28, 2009 at 5:28 AM, Dave <davidstev...@gmail.com> wrote: > >> >> 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 a macro 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 >> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
