VBA Compare and Match

Hi, I wonder whether someone may be able to help me please.

I've put together a small script to perform the following:

• Compare a list of staff names in columns B on the sheets "Flexible Resources List and "All Resources", and

• Where a match is found,

• Copy column H on the "Flexible Resources List" sheet and paste this into column H on the "All Resources" sheet.

This is the code I've put together so far:

Please Login or Register  to view this content.

I'd now like to adapt this a little, but I'm a little unsure about how to go about it.

I'd still like to copy and paste the data from, and to columns H on the respective sheets, but in addition, I'd now like to copy columns E, F and G from the "Flexible Resources List" and paste this to columns I, J, and K on the "All Resources" sheet.

I'm just not sure how to join multiple columns, so I just wondered if someone may be able to look at this please and offer some guidance on how I may go about achieving this.

Many thanks and kind regards

Hi @Izandol, thank you for taking the time to reply to my post.

It's interesting that you feel my code won't work. I must admit to receiving some help along the way, so I'm not 100% sure to the meaning of each line, but the code is working.

I did try the code you kindly provided, but unfortunately I was unable to get this to work, and although I didn't receieve any error, the values were not paste into the destination sheet.

You did however show me the right way to go about making the necessary changes.

So I changed:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

and the script now works perfectly.

Many thanks and kind regards

Hi @Izandol, thank you for taking the time to come back to me with this.

In bow down to your experience, but from the testing I did, I couldn't get this to work without the '0+3'.

Perhaps I included a typo when copying your code across, I'm not too sure.

Kind Regards

Hi @Izandol, I went back to look at the code, and I offer my apologies for the confusion and frustration, because your code works perfectly.

I must have included a typo when I initially put together the script with your code.

Once again, my apologies.

All the best and kind regards