+ Reply to Thread
Results 1 to 1 of 1

Create custom Excel report/table that automatically organizes and presents data by month

  1. #1
    Registered User
    Join Date
    06-21-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    1

    Create custom Excel report/table that automatically organizes and presents data by month

    Hi,

    I have a spreadsheet that keeps track of my team members travel information (attached). I would like to create another another tab that organizes the travel information by month in this fashion:

    January
    Tom | Thailand | Bangkok | Meeting 2 | 10 Jan 2013 | 11 Jan 2013
    John | Australia| Melbourne | Meeting | 24 Jan 2013 | 5 Feb 2013

    Feb
    Data of Feb travelers

    March
    Data of March travelers

    I have included a sample of the data and a rough idea of how the tab is going to be like. Should I create a pivot table or is there another way of doing this? I would appreciate any advice on this since I've been doing trials and errors for the past week and still can't find any solution.

    Thanks!

    DL
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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