Pivot Table / Chart

[DJGassman]

Hi,I hope there is a relatively easy solution to an issue I've tried to resolve and am completely stumped!!! The information I'm working relates to airline arrivals and departures.I get a simple spreadsheet on a monthly basis (I've attached an abbreviated copy) that tells me:Flight 123 will arrive at xx:xx time and depart at yy:yy time on dd/mm/yyFlight 234 will arrive at xx:xx time and depart at yy:yy time on dd/mm/yyetc.The problem I'm having is the format of the arrival and departure information: it currently is listed in the columns as "Effect" for the first date it will occur that month, and "Discon" for the last date it will occur that month. (ie: Flight 123 will start arriving on 4/02/11 and do so daily until 4/17/11.What I'm trying to do is manipulate the spreadsheet so it will display the info for the inclusive dates in between....ie: Flt 123 also comes in on 4/03/11, 4/04/11, etc. If it could do that, I could then do a simple pivot table based on the dates and arrival/departure times. (the second page of my attached sheet is the pivot table I've got so far).My goal with the pivot table is to reflect simply each day of the upcoming month, and to reflect the total flights arriving between 0700-0759hrs that day, between 0800-0859hrs that day, etc. Is this something someone could review and give me some guidance? I'm not very proficient at Excel yet, but I'm learning! Thank You,Dave(Also... if what I've described is possible, there will be another issue to deal with: the Column "Frequency" reports whether these flights are "daily", or limited to certain days of the week. (For instance "x7" means it does not operate on Sundays, "135" means it operates only Mon, Wed, and Fri. "Daily" of course means 7-days a week.)
The attached is an abbreviated version of the spreadsheet....

[DJGassman]

Bump No Response

[shg]

Try this:

Please Login or Register  to view this content.

[DJGassman]

Thank you so much for your time and effort! Could you now please explain how I "run" this code? My knowledge of Excel is pretty limited, and I really don't know how to apply this to a spreadsheet.

Dumb, I know... but I'm just learning about all this.

Thanks, Dave

[arthurbr]

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:

Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button