Data and number manipulation

Hello

I'm trying to accomplish something in Excel and simply don't know how to go about it. I am a a newbie.

I have a worksheet with data in it

5001 Data Data
5002 Data Data
5005 Data Data
5006 Data Data
5008 Data Data

I need to fill in the missing numbers so it looks like this:

5001 Data Data
5002 Data Data
5003
5004
5005 Data Data
5006 Data Data
5007
5008 Data Data

so, in summary, I need an add-in, marco or some method to add both the missing numbers AND a complete row.

Anyone know of any way to help, or am I stuck manually making these entries?

Remember, I am a complete newbie, please speak simply, I won't be insulted.

Thanks!

Hi There,

I have a similar issue but I fear it may be slightly more complex. The below table is an excerpt from a Telephone System showing the extension, the date and time as well as the duration of the call. I have added extra fields to split the date/time into Date and Time and an extra column to format the date field correctly. I also added the day of the week to allow averages to be made per weekday. Finally I have rounded down the time of the call to the nearest hour to be able to see how many calls are received per hour on a certain day. I have displayed this information in a pivot table and everything is working nicely.


A 20.01.2015 16:45 20.01.2015 20/01/2015 Tuesday 16:45 16:00 4:05
A 20.01.2015 17:47 20.01.2015 20/01/2015 Tuesday 17:47 17:00 0:36
A 20.01.2015 17:48 20.01.2015 20/01/2015 Tuesday 17:48 17:00 5:48
A 20.01.2015 18:20 20.01.2015 20/01/2015 Tuesday 18:20 18:00 0:00
A 20.01.2015 18:22 20.01.2015 20/01/2015 Tuesday 18:22 18:00 0:00
A 20.01.2015 18:27 20.01.2015 20/01/2015 Tuesday 18:27 18:00 0:00
A 20.01.2015 18:30 20.01.2015 20/01/2015 Tuesday 18:30 18:00 0:00

I have just been asked if I can show the number of calls for the complete business day, even if no calls were made or received (between 7am and 6pm). I have looked into several ways of doing this and am completely stuck!

Is there a way to do this without adding fields to the list for missing hours and adding the value 0:00 to the duration field? Can anyone give me a nudge in the right direction?

The method must be one that is universal as I plan to be implementing this into a macro to allow the person to simply open the txt, run the macro and get the same reports - even when there are different Extensions (sometimes there are 6 in the export.txt -sometimes up to 12), number of calls etc.

Any help would be greatly appreciated!