Macro of addcomment with vlookup value

Dear all,

i have to sheets.

board! (sheet which contains a table- created with macro)- each cell in the table desplay a project name
project! (sheet which contains the project data- name, status, priority, project manager....)

i need a macro that insert a comment in each cell (on "board" sheet), the comment will be set by vlookup value from the "project" sheet.

board range is board!D8:z70
lookup value is (board active cell, project!A:F, 6, true)

how can i create this macro?

Thanks in advance,
Best regards,
Ilil

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.




To add a file to a post

You can work with this,

Please Login or Register  to view this content.