Recent content by Verner

I am trying to setup a timesheet but don't want to rename the appropriate days of the week every week I start a new one. I simply want a template that adjusts the days of the week for the current week I am in. What I want to do is have some sort of function that generates dates for the current...

I have a large chunk of some production data - some 4000 lines and have it sorted by date. Is there a way to automatically segment the data so that I can put in a line or two under each date or to separate the data day-by-day so that I can minipulate certaion portions of the data?

I want to use the VLOOKUP function and return more than one value on one ore more different page in my spread sheet - is there. Is there a way to search an entire spreadsheet (multiple pages) and return or sum up ALL the values I am looking for?

I am checking out this thread because I am now going through my second run of converting a large schedule (greater than 3000 lines) from MS Project into Primavera which is costing us a great deal of money and will take a good month or so to get our schedule to a state that is functional. Judge...

I have had this problem when I am copying and pasting values from Excel. If this is what you are doing, use the "roundup" function in excel to calculate the values then import the values as integers.

I am finding that when I import a baseline from one schedule to another, I lose the baseline (bars) but the CPI and SPI values still remain correct. How do I keep the baseline from the imported schedule?

We would like to produce a "100-Day Schedule" from our current schedule (duration of this schedule is 5 years)Displaying only resource activities both on the Gantt Chart and in resource activities. When we filter for "date range" it will display that occur in this time frame and display them...

Primavera will do S-Curves for you.

Done - a 20second job via the wonderful world of Macros. Didn't know if there was already a predefined way. Thanks

Can anybody tell me the "Keyboard" shortcut for indenting text in a cell. i.e., I do not want to touch my mouse. Thanks

That's fine, but to change more than one bar at one time withoug selecting every bar individually.

If you are linking these dates to 2 separate tasks, you may want to set up a "Hammock". Follow the steps for this in the help menu. Cheers. MG

Is there a way to change the appearance of a group of bars in a Gantt chart - I want to change, say the colour for example of certain bars but not all. Thanks

Kewl - thanks guys - you just saved me loads of time!

I am looking for a way to standardize headers/footers on spreadsheets - for some reason I seem to think that you have to manually enter the headers/footers in for every page on a spreadsheet. Is there an easier way to do this?