Here is a description of the project I need to complete. I have an Excel spreadsheet where I need to automatically populate the comments field for specific cells with data from a lookup. The lookup data resides in the same spreadsheet, but in a different worksheet. There is a worksheet in the (attached to this project) XLS entitled "Values". There is a list of items in a column called "Value Number". What I need to do is lookup the corresponding Value Number in the "Lookup Table" worksheet, take the Text1, Text2, Text3, Text4, Text5, and Text6 columns associated with that Value Number and add them as a comment to the original Value Number cell on the "Values" worksheet, and highlight (bold) the Text1, Text3, and Text5 columns in the resulting comment. This needs to happen for each Value Number listed. You can have this script invoked when opening the XLS, or you can put a push button on the worksheet to invoke the script. I am also open to other ideas on how best to run the script to add the comments.
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).
Microsoft Excel - Windows