Copy rows to a given sheet based on several criteria

(posted as well here and here)

I've been looking for a solution for this, but couldn't find the right one (or ones to combine).

I have a sheet containing information.

Criteria 1. Column D contains a date of service. As soon as a date is entered in this column, it means the service has taken place and the row can be copied to the given servicesheet (see criteria 2).

Criteria 2. Column A contains a servicename, corresponding the sheet where the entire row has to be copied to. This column will basically be blank, and has to be chosen by the user by drop down menu. If a date is entered, and no servicename is given, an error should occur (if possible the error should occur after finishing the correct input).

3. Both columns (A and D) can contain blanks. To define to last row (if needed) column H can be mentioned (every used row will contain a value).

4. There are 20 (or so) different services, and 20 different sheets for these. For non existing services (sheets) an error should occur.

Summarized: If a date and service is entered, the row has to be copied (and deleted from origin) to the sheet mentioned in column A, to the first blank row of that sheet.

Thanks in advance!

Hello bfora,

Welcome to the Forum.

Please upload a sample WorkBook showing us what you have, and on another Sheet, how you would like the outcome to be.

You have a number of brilliant Forum Members on your doorstep, so to speak, who would be most willing to assist you.

welcome to the forum :-)

however, I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

no need-op has now done that as requested (though I recommend he or she does it in the other forums too!)

Thanks for advice and patience with newbies like me

[...]

EDIT: Problem is solved with this solution!