Moving on row to the next sheet when a field is filled with c

[Spoonfighter]

So i have been working on this and i am so close. I need to make it so when you enter c in column J it will delete that row and move it to sheet 2 to the next available row.
At this point i have it deleting the row and moving it over but it keeps using the same row and over writing the the lines already there.
Here is what i have gotten so far.

Please Login or Register  to view this content.

Thanks

[Solus Rankin]

Your post does not comply with rule #3.

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:

[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

... and appear like this when posted:

Please Login or Register  to view this content.

To edit please click the 'Edit Post' button below.

[Spoonfighter]

I added your [code] thing. It seems like it removed my code but i did what you asked. Still dose not answer my question. Any help would be great.

[Solus Rankin]

Please Login or Register  to view this content.

You have this in the worksheet activate event. Do you want this to happen every time a change is made in column J? or only when the worksheet is activated?

[Spoonfighter]

i want it to happen every time the vehicle a C is input in to column J. I thought active was the correct sub. Is there a different event i should be using?
Using your code worked.
I will have to look mine over and see what all i have incorrect as yours is much shorter and easier.
My first code but i want to start doing more.

Thanks Solus

[Solus Rankin]

Please Login or Register  to view this content.

This should it every time you place a c in column J.

[Spoonfighter]

Very cool, Thanks Man
This helps a lot

[Solus Rankin]

Glad to help.

If you are happy with the solution please mark the thread as [SOLVED] using the thread tools at the top.

And on any thread you can show your appreciation for anyone who has helped you by clicking the * below their post.

[Spoonfighter]

done and done. Thanks again