move or copy row to other sheets based on cell selection

[catherineburns]

Residential/nursing homes who fail to meet standards are placed on an improvement plan. We monitor against the standard throughout the lifetime of the plan. Providers can take time to progress their plans and consequently, in any month we visit we may find that a home has either "met" or "monitored but not met" the standard.


In my spreadsheet I need a total of 15 tabs:


Outstanding
A tab for each of the months (January – December)
Met

Monitored but not met tab



Outstanding Tab
Following completion of a visit one of two options in column A will be selected “monitored but unmet” or “met” and the month of the visit will be selected in column B.
If “met” is selected the row should move (i.e. the entire row deleted from the outstanding tab) to the relevant month tab.
If “monitored but unmet” is selected then the row should copy (i.e retain the row in the outstanding tab and automatically paste a copy)into the relevant month tab.


Met Tab
Will receive all rows that are set to “met” on the outstanding tab.


Monitored but unmet Tab
Will receive all rows that are set to “monitored but unmet” on the outstanding tab.

The outstanding tab will only retain those rows that have a blank setting in column A or a “monitored but not met setting” in column A

[alansidman]

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved 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-posted questions without a link to be closed and 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).


Crossposted at: http://www.mrexcel.com/forum/excel-q...her-sheet.html

[jaslake]

Hi Catherine

Welcome to the Forum!!!

You indicate

I need a total of 15 tabs

Your Workbook has only two Tabs (Worksheets).

Please add the required Worksheets with Header Rows and upload that revised Workbook. The Code could do it but I'd assume that's not required.

One of us will help.

@Alan
Sorry Alan...didn't refresh before I posted.