Convert raw planning data into a 'calendar type' view

G

Guest

I need to convert an information dump from a planning system my team uses
into an excel 'calendar type' view. The information dump into excel comprises
a column with an individuals name, a column with the project name, a column
with the project's start date and a column with the project's finish date.

The end product needs to show each individual's name down the left hand side
of the page, the year's dates along the top of the page and the date range
for each project blocked out with the name of the project identified on the
date range. This calander type view needs to be able to be refreshed when we
update the information dump from our planning system.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Anyway to transfer data from an excel spreadsheet to Project? 1
Problem with calendar planner date ranges 2
Creating a Calendar 2
Using Index, Match and Search to populate items to a calendar view 2
Convert 1 row of data into Multiple columns 1
Converting multiple rows of Excel data into Word Document 1
Macro to save information into a table 1
putting a column of names into alphabetical order 1

Top