Macrs with Validation Rules

C

Chris

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.
 
D

Don Guillett

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macros running with Validation Rules 2
Validation list from Named Ranges 5
Dynamic name range for use in data validation 1
Data Validation 2003, Named Ranges/Formulas 1
MACRO: Selecting "Cancel" from a drop down to copy and paste entirerow to another sheet 1
If Then with Validation 2
Stopping duplication within Data validation 1
Data Validation Not Erroring with List 2

Top