Hello all,
I am Hans van't Hof , new here and very little experience in VBA for Excel.
I would like to get some help on the below issue.
I have an excel file that gets data imported from another application.
The file has 2 sheets with a table on each of them.
First sheet:
Table 1.gif
Second sheet:
Table 2.gif
This excel file is used to visualize the status of an User Acceptance Test.
On sheet 1 I have listed a few Business Scenario's. Each scenario contains 1 or more steps.
The fields contain a test ID number.
On the second sheet I have a table showing the test ID number and a root cause. This table only contains data for Test Cases ID that failed.
What I am looking for is a VBA macro that can automatically populate a cell comment on the first sheet if a match is found based on Test Case ID in the second table. The comment should contain the root cause from the cell in the second table.
E.g.
Cell E2 (17859) should get a comment created based on matching cell in 2nd sheet, content in this case "System down"
Cell D4 (17460) should get a comment created based on matching cell in 2nd sheet, content in this case "User Access revoked"
Etc. etc
If no matching entry can be found in the second table based on Test Case ID number, then no comment should be created.
I hope I described it in a good enough way. I have attached an example file (as per above).
Thanks all in advance for your help.
Best regards
/Hans
Bookmarks