Question about Microsoft Excel for PC
Dear Friend, In my P6, if i check the monthly plan for my project, am getting a cumulative value.But if i go for the weekly distribution, i am getting a different value. For Ex. The cumulative percent planned upto the month of July is 17.5%, but in the weekly distribution, in 26th July itself my cumulative planned value is 18.07%. Could you please help me to solve this issue. Regards Nair
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
You can set a default value in most form items under the properties of that item. Look for "value". You can also do this in code, by setting up a sub routine to set/reset the values on your form. Then just run the sub routine before you open or enter the form.
Private Sub resetForm()
'formname.itemname = value
UserForm1.Label1 = "Hello World"
For the second one you have a couple of options, you can find the bottom on the data and store the row index in a variable, use a loop to find the next empty cell in a row, and store the value or you can use the current region method to select all the cells with data continously touching the selected range. Example below
numberOfRows = Sheet1.Range("A1").CurrentRegion.Rows.Count
Posted on Jul 19, 2008
When you say prepare . .
What data is going in - and what needs to come out ?
At the moment - it looks like you just need standard coloumn control...
From the standard input columns do you need to break the data down into specifics (Ie time frames etc...which will incorporate cumulatives..)
I would personally suggest using MS Access - you will have greater control and GUI to minimize accidental deletion etc..
Posted on Aug 18, 2008
Here is one way to do it:
1. In column A enter the name
2. In column B enter their start date in the format day-month-2008 (31-12-2008 for Dec. 31, 2008); if a day is less than 10, put zero in front (03, 04, etc.)
3. In column C put 31-12-2008 (December 31, 2008, the last day of the year)
4. In column D, put C1-B1 and format as a number with 2 places after the period (10.25 for example) if you want to track partial days, other format for no zeroes after the period (13)
5. In column E, put this formula:
(D2/30)*1.25 (assuming this is line 2)
You can then copy these lines as many times as you need to, total them, etc.
Posted on Dec 30, 2008
SOURCE: Change of colummn
' Dist1 Macro
' Keyboard Shortcut: Ctrl+Shift+D
Selection.TextToColumns Destination:=ActiveCell, DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=True, Other:=False, FieldInfo _
:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1)), _
' Dist2 Macro
' Keyboard Shortcut: Ctrl+Shift+M
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
if have any probs pl contact me
Posted on Mar 21, 2009
Tips for a great answer:
Jan 06, 2017 | The Computers & Internet
Oct 17, 2013 | 1996 Italdesign Formula
Nov 14, 2010 | Computers & Internet
Mar 08, 2009 | HP PSC 1210 All-In-One InkJet Printer
Feb 10, 2009 | Primavera Contractor 6.1 Full Version for...
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
14 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: