+ Reply to Thread
Results 1 to 2 of 2

Project Management in Excel?

  1. #1
    Registered User
    Join Date
    07-15-2006
    Posts
    30

    Project Management in Excel?

    My company does not have MS Project. We use excel extensively to plan out projects.

    Has anyone come up with a way to view a project plan on a calendar within excel?

    I have the following info in a spreadsheet:
    - Due Date
    - Estimated Hours
    - Asignee
    - Title

    I would like to create some sort of a macro to take the above information and spit out a calendar view so I can visually see where due dates fall.

    Any thoughts? Anyone doing anything like this?

    Thanks.

  2. #2
    Harald Staff
    Guest

    Re: Project Management in Excel?

    Hi Kesey

    Try John Walkenbachs gantt chart from
    http://www.j-walk.com/ss/excel/files/general.htm

    HTH. Best wishes Harald

    "Kesey" <Kesey.2b9zvw_1153452365.5705@excelforum-nospam.com> skrev i melding
    news:Kesey.2b9zvw_1153452365.5705@excelforum-nospam.com...
    >
    > My company does not have MS Project. We use excel extensively to plan
    > out projects.
    >
    > Has anyone come up with a way to view a project plan on a calendar
    > within excel?
    >
    > I have the following info in a spreadsheet:
    > - Due Date
    > - Estimated Hours
    > - Asignee
    > - Title
    >
    > I would like to create some sort of a macro to take the above
    > information and spit out a calendar view so I can visually see where
    > due dates fall.
    >
    > Any thoughts? Anyone doing anything like this?
    >
    > Thanks.
    >
    >
    > --
    > Kesey
    > ------------------------------------------------------------------------
    > Kesey's Profile:

    http://www.excelforum.com/member.php...o&userid=36402
    > View this thread: http://www.excelforum.com/showthread...hreadid=563558
    >




+ 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