Hello all, I would really appreciate some help writing the VBA for the following:
I currently have 2 worksheets (Dashboard and List). On the Dashboard worksheet the user can pull up different opportunity names and the sheet will give the user details about that opportunity. I am trying to allow a user to enter a comment into a cell in the dashboard tab, press a macro button and have that comment be transferred to a cell in the List worksheet within the appropriate row related to the opportunity the user selected on the dashboard sheet (for storage/tracking purposes). I can copy and paste the comment from the dashboard sheet to the list sheet, however, I don't know how to make the comment to go automatically to the specific cell next to the unique opportunity name.
thank you so much!
Bookmarks