LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 788
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros running with Validation Rules Chris Excel Worksheet Functions 2 March 9th 10 12:07 AM
making 2 (or more) validation rules for each cell ali Excel Discussion (Misc queries) 2 September 13th 07 04:26 AM
how do I set up a validation rules with two data rules Trudy Excel Worksheet Functions 1 October 16th 06 05:42 AM
Data Validation Rules Louise Excel Worksheet Functions 6 May 10th 06 01:02 PM
Exceptions to Validation Rules Jim Johnson Excel Worksheet Functions 5 November 7th 04 01:04 PM


All times are GMT +1. The time now is 10:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"