Search results for query: *

Thanks both, I have used the timeline but still seems a little basic. I have copied / pasted into PP before and it works ok, but I am aware there are various add-ons out there, and was wondering if anyone had used one that supported richer functionality / presentation options directly from MS...

Hi, Can anybody recommend an add-on for MS Project that facilitates executive management reporting please? Key requirements being: -Produce visually simple Gantt timelines comparable to a PowerPoint presentation rather than the standard MS Project Gantt timeline functionality. -Be able to...

Cheers Skip, this went well. Only minor config I needed to make was to change .Workbooks to .Worksheet. Thanks for your help!

Thanks Skip, Will give this a try.

Hi, Thank you for your replies. The sheet to receive the data is 'ConsolWeeklyExtract' Jon

Hi Skip, Thank you for your reply. I have re-posted and hopefully answered your questions. Regards Jon

Hi, I have multiple Excel workbook files stored in the same folder location, each workbook file has one worksheet with a table of data. Every table in each of the workbooks is in a consistent format (so the columns are in the same order with the same data type). Is anyone able to advise on a...

Hi, I have multiple Excel workbook files stored in the same folder location, each workbook file has one worksheet with a table of data. Every table in each of the workbooks is in a consistent format (so the columns are in the same order with the same data type). Is anyone able to advise on a...

Thanks John - have found some possibilities based on that search!

Hi, Does anyone know of a reasonably priced planning workshop tool out there? I am looking for something that is particularly good for initial brain-storming planning sessions to replace the 'large sheet of paper on the wall with post-its' approach. So it would allow: - The quick creation of...

Hi Julie, Thanks for getting back to me. The Resource Usage view does cover a good part of the requirement, in particular the grouping of the items by individual resource. But I also wanted to show with the project hierarchy maintained and a formatted Gantt view with milestones to the right...

Hi, I have created a view in MS Project 2013 that shows tasks grouped by Resource Name (via Views / Group By) similar to the standard 'Resource' Group By option. This works fine as long as there is only one Resource Name in the Resource Name column. However, if there are multiple names in the...

Thanks Julie, See what you mean re the Summary Roll Up - that may be an option for me. cheers for your help. J

Thanks, I am in 2007 though so not using manual scheduling. There are no issues with the summary row duration or dates, but other customised columns on the same row as the summary task. For example there is a column called 'Project Status'. This shows the basic status of the project such as...

Hi, I have a MSP programme plan that imports data from a large Excel spreadsheet and updates the task/milestone lines using an import map. These lines are grouped in the Excel doc by the project they relate to, with approx 200 projects. The Excel doc is basically a flat file, and does not...

Hi Skip, Thank you for your reply! Think I have sorted now using Index and Match combination.

Hi, Can anyone help with a suggestion for the following please? I apologise in advance for the long mail! I have a 'Milestone Exception Data' table in Excel that lists milestones (one per row) and gives Start / Finish dates for each milestone. There is also a column that shows days delay for...

Hi, Ideally I need to keep the same MSP file as there are other columns that are updated in the MSP plan that do not exist in the EPM extract. Re the merge-key - they are all unique, it is more that they vary in character length which for some reason throws the look-up...

Hi, I have set up some imports to take project plan data from an EPM data extract in Excel into an MSP plan, so that dates automatically update from the EPM data extract. End result is to show a high level roadmap with key dependencies in MSP. I am encountering two issues though, and wondered...

Thanks - yea that is a good interim solution. Cheers.