Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Twenny02
  • Content: Threads
  • Order by date
  1. Twenny02

    MS PROJECT ADD-ON FOR EXECUTIVE REPORTING

    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...
  2. Twenny02

    MACRO TO COMBINE DATA FROM MULTIPLE EXCEL WORKSHEETS INTO ONE EXCEL FILE

    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...
  3. Twenny02

    MACRO TO COMBINE DATA FROM MULTIPLE EXCEL WORKSHEETS INTO ONE EXCEL FILE.

    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...
  4. Twenny02

    PLANNING WORKSHOP TOOL

    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...
  5. Twenny02

    MS PROJECT 2013 GROUPING BY RESOURCE NAMES

    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...
  6. Twenny02

    Summary Row Delta Against Its Sub-Tasks

    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...
  7. Twenny02

    EXCEL LOOKUP HELP

    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...
  8. Twenny02

    IMPORTING INTO MSP FROM EXCEL

    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...
  9. Twenny02

    EXPORTING MS PROJECT VIEWS

    Hi, I have a large MS Project file (9mb) with different views. Is there a way (other than screen-print into Word / PowerPoint) that I can export / copy a selected gantt-chart view from MS Project (e.g. the timelines / milestone icons etc) so I can send to other people to view? The key...
  10. Twenny02

    Excel 2010 Conditional Formatting Using Formulas

    Hi, I am having problems with conditional formatting in Excel 2010. I want the format of a cell (column B) to change based on the value in column A. In column B, I am using the Conditional Formatting / New Rule / Formula to determine which cells to format option, and inserted the formula...
  11. Twenny02

    CRITICAL PATH ALTERNATIVE

    Hi, Slightly strange question but does anyone know of an alternative to the standard critical path analysis method (i.e. tasks - duration - dependencies - network diagram). I am creating a programme plan, so by its very nature it does not have all the detailed tasks and dependencies in. Many...
  12. Twenny02

    MS Porject 2007 - Filtering

    Hi, I have created a view and assigned a filter to it. The filter is very simple and designed to only show selected milestones, using a Flag column to show rows where the Flag value = Yes (i.e. is a selected milestone). Normal Tasks / other milestones should be hidden (Flag = No). However...

Part and Inventory Search

Back
Top