Hi,
I have a work sheet with codes categorized on column A and Comments for that code on Column B and Explanation of the code on Column C. When I am working, I have to search for each codes, read the explanation and then copy the comments to paste into my reconciliation software. I have more than 22 codes and it is lot time consuming, each time when I do copy and paste.
I have created buttons with code name on page 1. Can someone please help me to have a code that can assign to each button that when I press the button of a particular code, comments belongs to that particular code on page 2 (Column B) should be copied to memory, so that I can paste it to my reconciliation application. Also a message should appear with the explanation on Column C for that code. In this way I can save time by just a click on the code button.
Please someone help me to get a code that I can assign to these buttons which search for the code in column A and then copies the comment for that code in column B and displays the explanation for that code in Column C.
Note: Sample work book is attached
Bookmarks