LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default Dates in Excel

Hello,

Could someone please help me with the following:

I need to run a macro that lets the user know when a date has been on the
spreadsheet for exactly 14-calendar days.

The dates are in Column D of my spreadsheet named: AOG_UNDA Database. The
column header is named: Date Demanded.

77AVMF 0848
04
UNDA
04 Jun 2004
BATTERY STORAGE
66-090-1903
86Z
4
0
BMF

77AVMF 0849
04
UNDA
04 Jun 2004
CASE & VALVE ASSEMBLY
01-428-8889
904-002-786
35
0
OXY

77AVMF 0850
04
UNDA
09 Jun 2004
ELECTRON TUBE
01-269-5704
34-056085-02
1
0
EW



Shown above is a small portion of my spreadsheet. Column AF is the last
column on my spreadsheet.

I need to PrintPreview the output.

The macro needs to run once per day. So when the user opens up the
spreadsheet each day the macro needs to automatically run on start-up.

Any help would be greatly appreciated.

Kind regards,

Chris.



 
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
Linking computer dates (time) to spreadsheet dates that have formu bigisle Excel Worksheet Functions 3 January 3rd 10 08:05 PM
Excel not recognizing dates as dates lawson Excel Discussion (Misc queries) 1 June 26th 07 04:39 PM
how do I sort a column of random dates into Consecutive dates Rob Gibson Excel Worksheet Functions 2 June 12th 07 05:10 AM
Identifying unique dates within a range of cells containing dates cdavidson Excel Discussion (Misc queries) 0 October 12th 06 08:19 PM
How do I get the dates on an excel chart to stay as dates instead. Rani Charts and Charting in Excel 1 September 20th 05 05:56 PM


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

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

About Us

"It's about Microsoft Excel"