Results 1 to 17 of 17

consolidating multiple calendars into one

Threaded View

  1. #1
    Registered User
    Join Date
    05-29-2014
    Posts
    10

    consolidating multiple calendars into one

    This seems to be way more difficult than I anticipated, I just need a little help with consolidating. Tried the consolidate feature, however not sure that it is what I am looking for.

    I am basically trying to condense several calendars ( one calendar per department in a company) into one Calendar..Each calendar has its own tab and looks exactly the same. (tab names: Clubhouse, spa, and final calendar... possibly more departments added later) Hard to explaing so I will attach the file. All I would like to do is combine all calendars into the "final calendar" and in time order if possible... example below

    {Clubhouse Tab} A3 will have the time (10 am) , B3 will have the item "Meeting"
    {Clubhouse Tab} A4 will have the time (5 pm) , B4 will have the item "Dinner"

    {Spa Tab} A3 will have the time (12 pm) , B3 will have the item "Lunch"

    {Final Calandar} A3 will have the time (10 am) , B3 will have the item "Meeting" - from Clubhouse Tab
    {Final Calandar} A4 will have the time (12 pm) , B4 will have the item "Lunch" - from Spa Tab
    {Final Calandar} A5 will have the time (5 Pm) , B5 will have the item "Dinner" - from Clubhouse Tab

    If anyone can help with this I would appreciate it, and I can get a god night's sleep!
    Attached Files Attached Files
    Last edited by camri6; 05-29-2014 at 04:07 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Consolidating multiple sheets
    By johnnypol in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-01-2014, 11:38 AM
  2. Consolidating multiple files into one excel file with multiple tabs
    By Chemistification in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-13-2012, 06:23 AM
  3. Consolidating multiple spreadsheets
    By droo09 in forum Excel General
    Replies: 1
    Last Post: 05-10-2011, 03:36 PM
  4. Consolidating multiple worksheets
    By Prium in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-07-2008, 06:59 PM
  5. need help in consolidating multiple data
    By dromayn in forum Excel General
    Replies: 0
    Last Post: 12-06-2005, 06:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1