Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to create a list of records in another sheet, based on the entryof the word "Terminated" in a given column
Hello - Any chance someone has code that would allow the following.
In sheet1 I have a list of names that are being added as active members. When the members leave or terminate, we enter the word "terminated" in a column titled "Status." What I need is a record of all names that were terminated (on a separate sheet). So, ideally, I can come up with code that will automatically feed (a copy of) that entire record to a separate tab in that workbook, upon the changing of the status in that column to "terminated". The name of that other sheet is "Terminated Members." I will need that list of terminated members to stay in the "terminated members sheet", although I will eventually delete the entire record from from the Active Members sheet. Any code that would assist (or that is used for a similar set of circumstances) would be greatly appreciated. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
find "Cancellation" in column "A" and copy all data from Columns B-F onto another Sheet | Excel Programming | |||
cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
List "OPEN" orders based on a status column | Excel Worksheet Functions | |||
Please add a "sheet" function like "row" and "column" functions | Excel Programming |