find common value between two worksheet and copy data from 1 column.

[SierraKilo78]

Hi.

Need some help if someone may. I have 2 worksheets with data. I have a userform with a button, which when clicked, compares data between 2 worksheets and copies the entire row of the common data into a 3rd worksheet.

This is my code.

Please Login or Register  to view this content.

The above code copies the 1st 4 columns and pastes it to the 3rd worksheet. Along with this what I'm lukng to do is to copy the data from column I of wksQ of that particular common row and paste in column Z of wks1 I.e. My 3rd worksheet. Which means skipping a few columns in between. Not sure how to do it

Would appreciate all n any help.

[JBeaucaire]

Maybe this:

Please Login or Register  to view this content.

[millz]

Should be:

Please Login or Register  to view this content.

[JBeaucaire]

Yes, yes, of course!

[SierraKilo78]

Many thanks to both of u. Driving me way home so will try it in a bit and get back if its vot I was looking for. But in any case, ur help is much appreciated.

[JBeaucaire]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[SierraKilo78]

Gentlemen! Sorry for delay response but my PC at home ditched me yday. Tried the code rite now and works like a wonder. Thanks a zil to both u genius.