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 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...
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
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?
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...
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...
I am trying to rearrange my Gantt chart based on production.
I have the ability to advance at a total rate per day of 12.0m/day when I utilize my crew in several headings at once, but the crew can not affectively advance at this rate on any one single heading. I want to be able to tally up all...
I've run into a problem where some of the old boys at work have built some spreadsheets with a lot of data. The problem is that they've keyed in a substantial amount of data that and manually keyed in the measured units (in this case "m/day") in every cell instead of formatting it...
