cut and pasting data

[wyldjokre69]

Hello,

I hope you might be able to assist me with this query. I want to know if a vba can be created to find a value in a cell then cut and paste the data within a range to the next cell below. Example, in cell L is a value of 'x', I want to then cut cells E-O of that same row and paste it to the next row down, this will be done to all Values of 'x' in Cell L. My sample shows the Value of 'x' in Cell L.

CheerZ!
Wyldjokre69

Please Login or Register  to view this content.

Sample.xlsb

Please Login or Register  to view this content.

[Hawkeye16]

Do you want to overwrite the information in the row below or do you want to insert a new blank row and copy it there?

[wyldjokre69]

overwrite the information below by cutting rows E-O and pasting it in the next row below, so that the names in rows D & K match.

[Hawkeye16]

Ok - so in column L the second x should be in row 4 if I understand. I will code something in a second, have to go eat some cakes for a birthday quick.

[wyldjokre69]

yes, that is correct, eat a slice for me as well...trying to lose weight here...

[Hawkeye16]

If you get the x in the right places this should work, I can make it so it just looks off of the first column with a little more time. Sorry I am pretty busy today.

[wyldjokre69]

Hey Hawkeye16,

It's looking good, but it's off a bit, if I send you a piece of coding that kind of helped as well do you thing you would be able to tweak it so that it would be fully functional. The problem with this piece of coding is that it does match the highlighted horses and all data inbetween, but it also removes data. I'm hoping with your help, you will be able to apply it and then send it to me where it doesn't make data vanish. I hope you're kewl with this. I know your busy, so I will send you the coding and await your response. Thanks a million for your assistance.

CheerZ!
Wyldjokre69

Please Login or Register  to view this content.

[JOHN H. DAVIS]

FWIW:

Please Login or Register  to view this content.

[Hawkeye16]

That code looks overly complex to me and it overwrites data because it copies partial row and pastes without moving the data that is in the destination first.

Try this and let me know if it is what you want, if not I can build something into what you provided that makes it so it does not overwrite data. In the code I just provided it does not look at Column L, just matches the columns D and K which is what I suspect is the final goal.

Please Login or Register  to view this content.

[wyldjokre69]

It doesn't quite finish the job, would you be able to tweak the coding I sent you to not take out the additional info, that would be awesome.

CheerZ!
Wyldjokre69

[wyldjokre69]

Hello Hawkeye16,

Wow, you did it, I re-tried your code and it worked all the way to the last cell that was needed.

Thank you very much for your assistance, please disregard my last reply. I'm closing this query and giving you a reputation point.

CheerZ!
Wyldjokre69

This is the coding that worked it's magic:

Please Login or Register  to view this content.

[Hawkeye16]

Thanks for the rep! Glad it worked out.