Paste data from one worksheet to another workbook using command button

Hi Experts. I am hoping you can help me. I have created a log in excel which contains two text boxes and two combo boxes (activeX controls). When the command button is clicked, I would like the data in the text boxes to be transferred to the tab that has the same name as the selection in combobox1 and the column on that tab that has the same name as the data in combobox 2. The location of these tabs and columns is in another workbook.

So, data is entered in workbook1 (Errors). When I click command button, the date (textbox1) and value (textbox2) should be transferred to workbook2 (Tracker) and placed on the next available row on the tab that has the same name as what is in combobox 1 (Type). The date should always be in column A, and the value in textbox2 should appear in the same row as the date, but in the column that has the same name as what was in combobox2. Data from all boxes should clear after clicking command button. If anyone can help me, I would appreciate it. Thanks.

Hi Tinbendr. Thanks so much for your help. See you noticed the summary tab. My original thought was to have all of the data go to the summary tab so that I can review/edit if necessary before moving to the next workbook. But, that wasn't working for me either, so I just went the direct route. Would I need another macro to do that?

I tried the code you provided and it works perfectly when the second workbook (Tracker) is open, but not when it is closed. I get Run-time error '1004' tracker.xlsx could not be found. Debugger points to 'Set WB2 = Workbooks.Open(WBDestName, False, False). Do I need to add the path for the tracker.xlsx workbook to the code? Thanks again.

That did it !! Thanks so much for taking the time to help me. I will start a new thread for the summary!!