Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?

Reply
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
How do I create a schedule from a list of dates ? Gavin Morris Charts and Charting in Excel 2 October 28th 10 04:08 PM
Add worksheet Lookup based on date edwardpestian Excel Worksheet Functions 4 July 12th 06 08:07 AM
Insert new date once. Eric Vogel Excel Worksheet Functions 1 July 6th 06 04:17 PM
How to return a value between date ranges Mary-Lou Excel Worksheet Functions 7 May 26th 06 10:00 PM
Date updates from worksheet to chart & changes date to a date series! Help!! Jayjg Charts and Charting in Excel 2 January 22nd 05 03:00 PM


All times are GMT +1. The time now is 03:55 AM.

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"