Need Special Scheduling Report Help

Keith,

I appreciate your taking the time to respond to my request.  I may be missing something, but I did not see anything that will meet my need.  To summarize, what I need is similar to a Gant chart with these characteristics:

1. A report with dates as the X axis and DumpsterID as the Y axis.
2. Each DumpsterID may have more than one assigned date range.  For instance DumpsterID 15-10 may be scheduled for 8/2-8/6, 8/12-8/16, and ...
3. Each DumpsterID will only be found in one row regardless of how many assigned date ranges exist.
4. I would like to be able to color code each bar (representing one date range) depending in Dumpster size (first two characters of the DumpsterID) and whether the start date for the date range has passed (already deployed).
5. I would prefer to build for up to 500 DumpsterIDs.

I can easily create the macros to build the report by merging cells, filling backgrounds, providing captions for each date range, ....  My challenge is how to create an .xlsm file to download to excel.  I guess I could create a macro, put it in the Excel global location, and the put a button to invoke the macro on the toolbar, but I still don�t know how to create an .xlsx file with the data to download to Excel .  I can download the file as a .csv and then have the macro create the .xlsx file.  Sorry for the rambling, but I am thinking as I write.  See the file attached to the original request for an example.

With all of this said, I need this report available on mobile devices and macros are not yet supported on mobile devices. 

Am I missing something in your toolset?  If so, can you help me see what I am missing?