dcsimg


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Future dates

  1. #1
    Join Date
    Feb 2009
    Posts
    1

    Future dates


    Working in Excel 2003.

    Looking for code, so as to make this work please.

    Have 4 worksheets in workbook,but we`re only intrested in two.
    Named, ( letter ) & ( certificates ).
    There are only 4 columns in certificates sheet i`am intrested in,
    C,D,E,G, rows 2:1000, one column ( G ) has conditional formatting, (future dates) in it.
    Once condition is met,ie:- 30 DAYS BEFORE future date expires.cell changes colour(GREY).
    On colour change,Copy and paste the row, (cells under C,D,E,& G,) or rows,
    (there may be more than one) into letter sheet, columns B,E,H,rows 64:100.
    Then print, and clear.
    That`s it.
    Worksheet enclosed.

    Thank you for your intrest.

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    Quote Originally Posted by busman View Post
    Worksheet enclosed.
    Where?

Similar Threads

  1. Using Data Access & dates (simple question!)
    By Neil Martin in forum VB Classic
    Replies: 4
    Last Post: 08-15-2002, 11:16 AM
  2. Replies: 0
    Last Post: 01-16-2002, 01:29 AM
  3. Multiple dates for one database entry
    By Seg in forum ASP.NET
    Replies: 5
    Last Post: 12-19-2001, 12:50 AM
  4. Future of Web Programming ???
    By Gary Blakely in forum ASP.NET
    Replies: 2
    Last Post: 12-05-2000, 11:20 AM
  5. How to compare dates to get desired results... ?
    By Jaikumar Sharma in forum VB Classic
    Replies: 2
    Last Post: 04-01-2000, 12:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center