Find value and copy the Range to another sheet with merged cells

Hi All,

I made a lot serach on the forums and google and I found a couple of possible solutions about my problem but still the codes do not work as I like. My problem is;

I would like to find an exact value from a column and then to copy whole rows and colums which are the value that I found. My problem is, I can find the value and copy the rows and colums to another sheet but the code just copy the rows. Merged cells look empty. I would like to copy the rows and colums like I did manually select then do copy and paste.

I uploaded the template file that I use. In that file as you can see with blue mark, I would like to copy the merged rows exaclty as it is seen which is 17082018/17 to another sheet with VBA.

Thank you in advance...

thank you quick response. But I don't want to unmerged the cells. I would like to copy all from B19 to R28 to another sheet while they are merged. I think the code should find the first row and last row of which are "18" at A column and then should copy with this range (from B19 to R28) - to another sheet. but I think we should do this with varianbles.

Thank you so much kvsrinivasamurthy! The code works perferct!

Originally Posted by kvsrinivasamurthy

Thanks for the compliment.

I had an issue about the code. If I write 17072018/01 to "B2" the code copy all the rows from 17072018/01 to 17072018/17. I need to copy just related row. I tried to modify the codes but I couldn't make it work properly. Could you please help me to revise that? Thank you.

It didn't work. Now it doesn't copy the merged cells. I revised the code like this;

Please Login or Register  to view this content.

I put "1" to A colum which has merged cells. With If condition now the code can work as I like. Than your for your guidence.