Search results for query: *

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?

Thanks MortenA but if I wanted to export the two segments to the cell (i.e., the number and the unit) to two different cells, is there an easy way to do this?

I would like to split the contents of a cell into 2 parts (currently, I have a column of entrys that denote a distance - i.e, 40m 45m 50m ....etc) Is there a way to split these cells so that the number number is in one cell and the 'm' is in the other? (a reverse...

If the two dwgs are in 3-d, draw a line in one from any point in space to (0,0,0). Copy the entire drawing including the new line and paste it into the new drawing. Now move all you have moved from the point (0,0,0) on the line.

I don't think anybody understands what I am looking for so I will restate it: I do a great deal of estimating where I have to go through large amounts of data. Say I was updating a line and want just want to highlight it (i.e., change the colour of the cell to yellow), to show that I have...

I have a massive chart that gives a constant with Temp and Humidity as my variables. I have Temperature on the Y-Axis and Humidity on the X-Axis and for some reason can't figure out how to use VLOOKUP and HLOOKUP together so that EXCEL will pick out the constant on the chart for me. Is there a...