I need you!: Can I find/match cell in column then paste partial row?

Thank you so much for checking this out.
Combo box 1 selects the appropriate sheet. ComboBox 3 selects the available time. The active sheet active cell picks the row with the right cells to copy.
All good until...command button2 action.....sheet (combobox1.value) needs to find or match combobox2.value and paste the values into the row. Sounds easy enough don't you think? I bet there is a simple answer but alas, I have no more hair to pull or tum's to chew! Please let me know what a dufis I am by fixing this....Please.

Here is the code:

Please Login or Register  to view this content.

I'm almost sure it's because it's not able to Find tme. Try this code. If you get the message box "Talent Not Found", then you'll need to attach an example workbook so we can see why tme is not being found when you think it should be.

Please Login or Register  to view this content.

Attach an example workbook anyway. Make it easier for everyone to help you.

Regards, TMS

So sorry it will have to wait til Monday.

No worries. Enjoy your weekend

You're welcome

So, we're done here?


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.