Automatically cutting and pasting a row to another sheet when 2 conditions are met.

Hello Excel Gurus!

First off, thanks for even reading this. Your assistance is priceless. This is only the 2nd time I've consulted with the greats and I am very novice (1st time) user of Visual Basic and Macros.

I did some research and found some examples online but I can't get them to work. I am hoping you can help.

A little background:

This is a 2 sheet worksheet for a maintenance company. 1st sheet is labeled "Active" and the 2nd sheet is labeled "Completed". The goal is for when employees fill in 'both' the 5th and 6th column (any text, number, date, etc) on the Active sheet, that the entire row is cut and pasted into the Completed sheet. Sounds simple enough, right!? haha, much to my surprise, not that easy. I tried the macro recorder and that was an epic fail.

Here is what I have so far. Excel is giving back a 'Run-time error '13'' - type mismatch and it is highlighting this code as the issue: Worksheets("Completed").Cells(b + 1, 1).Select

-----------------------------------------------------------------------------------------------------------------------------------------

Please Login or Register  to view this content.

--------------------------------------------------------------------------------------------------------------------------------------

Some fantasies of mine with this project - I say fantasies because I don't know if they are possible

1. Can this happen automatically upon saving the worksheet or even just as soon as something goes into those two fields then the macro runs automatically?

2. Can we program Excel to delete the row it leaves behind?

THANK YOU for any responses!

Thanks for responding!

It is changing it to this and giving an error that says "Compile error: Expected: Then or GoTo"

Please Login or Register  to view this content.

Any help is appreciated! Thanks!

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. Because you are new to the forum, I have added them for you today. Please read our forum rules and abide by them in the future.)

Additionally, do not ignore requests from senior members and moderators. Future action of this type may result in infractions or banishment. We take our rules seriously.

My take on the matter, see attachment for a working example. Here is the code located in the worksheet code:

Please Login or Register  to view this content.

Originally Posted by Onefynebarraza

Banaanas,

I noticed that the cell will stay blank on the other side. Is there code to delete the cell after it has been removed?

Sometimes there will be tasks that will finish before others and it would be convenient not to have to delete the line after it moves over.

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.