View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] bkoliver@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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?