Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macrs with Validation Rules
I have a spread sheet with a tab called Estimnates once the Validation Item
for the estimated item is changed to "Contracted" I want it to Copy the Entire row to another Sheet called Contracted Projects. Is this possible? Would the best Option be to have it Copy all Items listed "Contracted" when the Workbook it closed or upon clicking a select button? I can not have it duplicate Items. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macrs with Validation Rules
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "Chris" wrote in message ... I have a spread sheet with a tab called Estimnates once the Validation Item for the estimated item is changed to "Contracted" I want it to Copy the Entire row to another Sheet called Contracted Projects. Is this possible? Would the best Option be to have it Copy all Items listed "Contracted" when the Workbook it closed or upon clicking a select button? I can not have it duplicate Items. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros running with Validation Rules | Excel Worksheet Functions | |||
making 2 (or more) validation rules for each cell | Excel Discussion (Misc queries) | |||
how do I set up a validation rules with two data rules | Excel Worksheet Functions | |||
Data Validation Rules | Excel Worksheet Functions | |||
Exceptions to Validation Rules | Excel Worksheet Functions |