Hi, I'm new to this. Basically, I've got a vba that sends emails to particular companies requesting particular files. I want to add a "Sent" button coded, so that when I click it, it will insert a date stamp of todays date into a different sheet in a row labled "Date Sent", corresponding to the particular company that the email will be sent to. Lets say that the company's name is in a list from a dropdown list in Sheet1 in B26. I want the "Sent" button to grab that company name in Sheet1 B26, and search for a match in sheet2 Column 3, find the match, and record a date stamp in the cell to the left of the company in the "Date Sent" column. (Sheet 2 Column 2) Any help would be appreciated. Thanks
Bookmarks