Find and match cell text value on another sheet and paste row on correct row number

Hi all,

I'm looking to refine the macro below I have recorded to find the value on "Sheet6" in cell H3 (the name of the person) on the "Availability" sheet and paste it across from column B. However, being new to VBA in the main I am unsure how to do this. I recorded the macro using the basic "find" option but of course this only finds the name of the person I specified. Hopefully you can help.

The info I want pasted from Sheet 6 is contained in cells B6:M6 and I want it pasted from columns B:M across the row on the Availability sheet where the corresponding name of the person is in column A. Hope this makes sense. I've attached the workbook so hopefully this will make sense.

It's a work in progress I inherited from someone else, so eventually parts are going to be hidden, which is why the vba needs to be fired from a submit button rather than using vlookup etc.

Please Login or Register  to view this content.

Thank you,
Smash.

Hi Mumps, thanks for taking the time to reply.

The names are all located in the data sheet, I just want it to search for the name in the drop-down in H3 on Sheet 6 and then paste them from B to M on the correspondng row of Availability where that name is in Column A.

Does that make sense?

Hope so.

Smash

Hi Mumps.

Yes the data is in those cells with the times in, B6:M6 on the front sheet, "Sheet 6" and I want it to copy and paste special to the corresponding row on "Availability" that matches the name in H3.

Thank you for helping

Thanks very much, Mumps - that does work fine, but is there any way it can work through the user pressing the submit button? I want them to be able to select their name, fill in the times and press submit.

Apologies for the faffing about, but being for work I'm trying to follow what people are used to and then build on it with ideas of my own (and the use of some books on VBA I have bought).

Mumps you are great, thank you!

Mumps, I have just one other question if you don't mind, is there a little tweak that can be done so it pastes special, values only? I tried the addition of

Please Login or Register  to view this content.

but it threw me an error.

Thanks so much for your help.

Thank you Mumps - I almost had it at one point after looking it up in one of the books I just got but I know it's going to take me a while to get to grips with it.

Really appreciate your help buddy