Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
insert row into worksheet when date missing
I have an excel sheet that displays daily numbers per application.
Unfortunately if the application didn't receive calls it doesn't show the date. Calls Application 1 10/30/2006 100 10/31/2006 120 11/1/2006 110 Application Summary 330 Application 2 10/30/2006 6 11/1/2006 2 Application Summary 8 I need a macro to automatically insert rows so that there are 7 days a week instead of just the days that have calls. Anyway to get this to work? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Add worksheet Lookup based on date | Excel Worksheet Functions | |||
Insert new date once. | Excel Worksheet Functions | |||
How to return a value between date ranges | Excel Worksheet Functions | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |