Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.


--
Kesey
------------------------------------------------------------------------
Kesey's Profile: http://www.excelforum.com/member.php...o&userid=36402
View this thread: http://www.excelforum.com/showthread...hreadid=563558

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,327
Default 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" skrev i melding
...

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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 12:46 PM
Multiple Excel versions. Naveen Mukkelli Excel Discussion (Misc queries) 0 May 16th 06 01:55 AM
Is Excel the way to go for this Project? Leah Excel Discussion (Misc queries) 3 May 9th 06 12:45 AM
How can I move Project tasks into an Excel outline? Russell Daum Excel Discussion (Misc queries) 0 June 24th 05 05:12 PM
How do I create project schedule using excel - office 2000 raeisza Excel Discussion (Misc queries) 1 January 5th 05 09:31 AM


All times are GMT +1. The time now is 06:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"