This forum does have value!
As year end approaches and I am considering upgrading to Money 2005, I found
the message traffic extremely valuable. After this summers fiasco with the
update to MSN Money locking us out of our local data file, I thought, or was
hoping M$ would make an extra effort to make sure that Money 2005 was a
significant improvement and without the assorted problems that I have found
posted here. Some still unresolved.
I have made my decision and I do not care how much work it is going to take
me, bt I am going back to Quicken after giving Money a two year trial. This
program is just not ready f...Create a line graph of quanitity of values
Hi, I am terrible with excel so I really appreciate the suggestions, in
I am using excel to create a graph showing the ages of my employees. I'd
like to show the demographic.... maybe a bar graph? Probably putting the
quantity of employees on the Y axis and the age ranges on the X axis. How do
I go about this? Can I make this from a selection of just ages, or do I need
to create a new table showing the information I want to graph?
You need to use an intermediate table. Charts only show values, they don't
calculate values. But you have this great worksheet fu...Use values instead of labels on X-axis in Area/Stacked Area Charts
When building a stacked area chart, independent of how the linked cells are
formatted, the chart uses the x-axis values as simple text labels. Since my
values are not equally spaced, this distorts the plot, and I have not found
any method through the help menus to change this formatting.
Any help would be greatly appreciated.
This technique might give you some ideas:
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
I am using the sumproduct formula below to pull information from one work
sheet to another. However some of the values in the range ranking order
E5:E38 are blank. The rest are 0% to 100%. I need to get my formula to return
blank instead of Zero unless the value in col E actually is Zero. I have
tried IF on it's own as well however I am not getting result I am looking
for. Any help appreciated!
Formula - =IF(ISBLANK(SUMPRODUCT(--('RANKING ORDER'!A$8:A$35=A8)*(--'RANKING
ORDER'!E$8:E$35))),"",(SUMPRODUCT(--('RANKING ORDER'!A$8:A$35=A8)*(-...Cards>>Fixed Assets should include Cost and Salvage Value
Cost, salvage value, depreciation method, and useful life are all basic
information that should be on the main card for Fixed Assets. It's fine to
have the flexibility to have alternatives for tax purposes in other Books.
But there should be a complete redesign of Fixed Assets that allows for the
basics to be easily "got to" on the main card with little trouble. As it is,
it's a menu nightmare. It's trying to be all things to all people and
succeeding at being a mess.
This post is a suggestion for Microsoft, and Microsoft responds to the
sugge...Net Gains/Losses on Investments Incorrect in Money PLus
I have the new Money Plus deluxe edition, and have noticed that in my
investments, the Market Value - cost basis is not equalling the "net gain"
column in my investment snapshot column, which I do not understand. It is
not off by a little; in some cases it is by a lot. I do not own many stocks
and funds but have no idea why this is off; t should be simple math. There
were some dividends but that should just affect the cost basis of my stock,
and in turn, that number would effect my gain or loss. Is anyone else
noticing this problem? Am I looking at something wrong here or...Loop through a Control to see its value
I have tried many many ways but I just can't get it to work so any ideas are
welcomed. I have a Tests database that has a Form with a subform in it.
I am trying to search for "Fail" value in a control named "PASS_FAIL" in the
subform named "AMC_ResultsB" . If it finds the control value to be "Fail"
then it should set the value of another control "OverAllPassFail" to "Fail"
(this control is in the main form). This way I ensure that if any test
results failed I can Flag the whole test header as Failed.
Here is the code
Ove...Changing costing methods
Our auditors want us to change our cost method from average to FIFO
perpetual. Other than using the utility to change each item, what other
considerations are there? Is there documentation on this? Thank you......
There is no real documentation but here is what you need to do.
MAKE A BACKUP FIRST!!!!!!!!!!!!!!!!!!!
1. Make sure your stock status by account number balances to GL.
2. Post all sales orders that can be posted and delete the rest.
3. Receive all the POs you can and invoice them. Delete the rest.
4. Use the utility (it will not change items on Sales Orders or POs
5. ...Formula to extract number values only
I can't seem to remember how to use a formula to extract numbers only. For
example, I would like to take a create a formula to pull only "3.5" for a
cell that containts "Sum: 3.5"...
In your example, you could use:
If your cells follow a pattern of:
You can use:
*Remember to click "yes" if this post helped you!*
> I can't seem to remember how to use a formula to extract numbers onl...Is an event triggered when a cell value changes?
I would like to run a sub when the value is several cells changes,
independently. Is there an event triggered when this happens that I can
use to initiate my procedure?
Thank you much,
Worksheet's Change event is triggered, whenever a change is made on sheet.
(When sending e-mail, use address email@example.com)
"Sharon" <firstname.lastname@example.org> wrote in message
> I would like to run a sub when the value is several cells changes,
> independently. Is there an event triggered when this happens th...using NZ() function to return ''0'' value when query is null
I have a form called tbldocinput that contains a subform countrack. The
form countrack is behind a query also called countrack that will provide me
with the MAX() of the value of a tracking number that I am trying to create
I want the user to input the data on the tbldocinput form which is
essentially a data entry form. When the user clicks save, the countrack is
requery as well as a unbound field on the form tbldocinput that is default to
If there is a value in the countrack form field dtrack, then I want to use
that value to input in my tracking nu...Multiple series with different x-values on one scatter plot
I'm trying to add a new series to a scatter plot in Excel,
but the new series uses a different set of x-values. I
want to plot it along the same axis as the other series,
but Excel plots the first point at (1, #) and the second
point at (2, #), etc., instead of actually reading in the
x-value and putting it at that place on the plot.
How can I change this so that it plots the point at the
correct/actual x,y values?
Let's say you have a chart with the first data series displayed.
Now select the data (the x-values and y-values ) for the new data series and
click the Copy to...IE load incorrect dll in ActiveX package
I have a problem with IE behavior when loading dll in ActiveX control.
The scenario is
1. Open IE load a ActiveX control including a.ocx and a.dll
2. Change IE URL to load another ActiveX control including b.ocx and
I find that when IE load 2nd ActiveX control, it will load b.ocx and
If I open a new IE and load 2nd ActiveX, it will load correct a.dll.
Is this correct IE behavior? Can I aviod it?
Dont know the reason but it could be because it probably looks at what is
currently loaded and doesnt bother to find it if the name/checksum ...Turn On A UserForm If Any Values Changes Within A Named Range
I have an entry sheet that calls up several UserForms to help enter in
data. In redesigning this sheet, I realized that I don't know how to
use an entry into a cell within a named range to trigger a UserForm to
Right now, I have three Command Buttons (Button 1, Button 2 and Button
3). Button's 1 & 2 will make themselves not visible and make the
CommandButton called "SAVE" visible - these work fine.
It is Button 3 that needs the adjustment. At present, by pushing it,
I go directly to the next step in the entry process. This is a
mistake. ...POP-SOP Link: PO invoice cost different than PO receipt
If we use the POP-SOP link, the PO is received and then the sales order is
transferred to an invoice and posted. Later the PO invoice is entered at a
higher unit cost. Shouldn't the COGS account be debited instead of the
Inventory account for the cost difference?
What valuation method are you using Elaine?
MCP-GP, MCT, MVP
East Coast Dynamics
FIFO but I'd like to know how it also works with Average Perpetual
"Frank Hamelly, MCP-GP, MCT, MVP" wrote:
> What valuation method are you using El...fill cells with a value from two previous cells
I try to copy the letter value from column A and B to column C in the
example below with a formula:
A B C
2 I I
Maybe this in Cell C1 and copy down........
Vaya con Dios,
> I try to copy the letter value from column A and B to column C in the
> example below with a formula:
> A B C
> 1A A
> 2 I I
Assuming that there is a value in only column A or column B, ...Inifinity value? URGENT!
I am trying to exclude a value which is being use for some of my
formulas, using the solver. Is there anyway to add constraints such as
putting the value to Infinity so it would be as good as excluding it?
The value sets the maximum my amount can reach.
aeiou's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25595
View this thread: http://www.excelforum.com/showthread.php?threadid=394967
aeiou <email@example.com> wrote in
news:aei...Counting with two criteria where one is between values
I have a spreadsheet with details of client contacts.
Column H - users enter "X" when client has had first appointment
Column I - users enter time (in weeks) client has waited for the appointment
I need to return how many clients waited 0-8 weeks, 9-13weeks and 13-18 weeks
I can count how many waited <8 weeks using
How can I count with the first criteria being an X in column h and the
second criteria being between the values of 9 and 13?
Thanks very much to anyone who is able to help me, it is very much
appreciate...calcluating a value if the original value meets a condition
Hello, I'm very new to Access, and I'm having a headache trying to set up and
run queries for the first time. I'm used to doing things in Excel and SPSS,
and maybe having a hard time adjusting to how the things are done in Access.
What I'm trying to do is this:
I'm trying to set up an accounting database, where you enter the amount of
money (from vouchers, etc.) that you spend. I have the "amount" field, and
some of the values in the field may already have taxes added, some do not
have it added yet (so need to have it added), and some are not taxed (so no
...Conditional cell values
Does anyone know if it is possible to make the input conditions of
cell dependent on the value/formula of/in another cell WITHOUT usin
something like the example:
if (cell_a = pre_defined_value_a OR
some_condition/formula_is_true/false) then (cell_b
some_condition/formula) otherwise (user_can_enter_a_value OR
Message posted from http://www.ExcelForum.com
..."Scaling of Decimal Value Resulted in data Truncation"
Our AS400 was recently upgraded to V5R2..and now some
tables that poreviously imported with no problems are
generating this error message. Does anyone know of this
Any help would be most appreciated.
...copy sheets values
i have a question;
Is it possible to copy values (A2:Z500) from a sheet name "Data" in a
worksheet name "BdData.xls" to an other worksheets but not in the same
folder as the first, and in this worksheet name "BbData.xls" values would be
in the sheets "Data".
Thanks a lot for all your advices.
Open both files and use Edit|Copy (xl2003 menus) to copy the range.
Go to the other worksheet in the other workbook and select the top left cell of
the destination range.
Then Edit|Paste (or Edit|Paste special|values).
If ...Lookup value, but between dates
I am needing some help on this situation. I have the data structured
in this way:
A B C
Res ID Cost Activity Date
1 1234 $20 1/1/2010
2 1234 $25 1/20/2010
3 7432 $15 2/2/2010
4 2574 $45 10/1/2009
5 7432 $65 1/2/2010
It shows by resource (Col A), Hourly Cost (Col B), and Activity date
Then I have a second sheet, with this format:
A B C
Res ID Cost Effective Date
1 1234 $15 12/30/2009
2 1234 $18 1/18/2010
3 7432 $12 1/31/2010
4 2574 $43 9/29/2009
5 7432 $67 12/31/2009
Same format, but it shows the standard cost. Effective Date represe...reference cell value from fixed column with variable row
template wizard wont let me select a form control (combo box) value to
associate a field with but provides a reference cell value which gives me the
row number in the other workbook of the value. how do i make a valid cell
reference from this reference? i.e. col of referenced value is "A", row is
variable depending on what value i pick in combo box. how do i make a
reference out of "A" plus the value to equal "A5" ? (so that i can associate
a field with it using the template wizard)
...need help creating formula based on cell value
Is it possible to create a formula using a cell value to create a formula.
basically I have multiple sheets with the name as a month. I have one sheet
that does my reporting. So Instead of having a to create a seperate formula
in each cell to reference each month (ie. ='jan report'!$A$14, ='feb
report'!$A$14, etc) I want to be able to do something like create a formula
to reference a cell that would contain the month name. For example.
a2 ="'" & A1 & " Report'!" & $A$14