Need data from a simulator schedule (excel calendar view) to auto populate to a worksheet

I am in the military and I am developing a sharepoint site to handle our simulator scheduling. Military sharepoint sites will not allow for direct excel export due to IA requirements. I have an excel spreadsheet that we use as a calendar view (attached) that I need to maintain for monthly scheduling. I would like to use this calendar to continue to populate the monthly schedule for detailed planning and visual depiction, the issue I need resolved, due to my novice excel capabilities, is to have the data from the calendar view auto populate to another worksheet or if easier to the same worksheet (out of the calendar view). I need this populated data to be in the order and format listed on the second worksheet "Charlie". The first column I can populate with text "Charlie". I need the populated worksheet "Charlie" with the specific information to upload the compiled data to our share point site using the the "edit in data" view.

Device Unit Start Time End Time
Charlie Auto Auto Auto

Requirements: I need to change this monthly calendar monthly and we need to account for work days, we do work weekends occasionally. But each month I need to reset the sheet to accomodate for the simulator schedule.

I thank you in advance for all of your help and advice, I have tried for a few weeks with no success.

Thank you very much, KeithScheduling Help.xls

Hi

The following macro will work in your spreadsheet and populate the Charlie worksheet as required:

Please Login or Register  to view this content.

Let me know if you need some help implementing it.

Best regards, Rob.

Rob, you are a life saver. Thank you very much for the assistance it worked perfectly. The MACRO is just what I needed.

Thanks again,

Keith