I am having trouble finding clear information and advice about how to set up
my Money file.
I would like to set up Money so that my girlfriend and I can track bank
accounts, investments and expenses that we have jointly (including our
mortgage and rental property). However, we also both have separate bank
accounts, investments and expenses that are unrelated to each other. I don't
know whether I should set up two separate files or set up all of our
information in one file that we have to share. I really want to avoid having
to enter our shared accounts and expenses twice, so ...Income Statements in FRx
When creating the Balance Sheet, I can use Account Type
(which links to the Great Plains 'Category' field on the
Account Maintenance screen) as opposed to specifying all
accounts to pull and summarize information. This helps
ensure that when I add a new account to GP, that it will
be included automatically on my report.
For the Income Statement, I would like to to use Account
Type also, but I would like for it to detail all
accounts, instead of just a summary.
For instance, instead of looking like this:
I want the deta...merging two cells without loosing data
If i have data in cell a1 that says "1234 brown st" and data in cell a2 that
says "Anytown, WY 12345", how do I merge the two cells and not loose any data
so that cell a1 will have the value "1234 brown st Anytown, WY 12345" ???????
I'd use a helper column of cells and hide column A:
I'd keep the data as granular as possible. It's really easy to concatenate--but
can get real hairy to separate.
> If i have data in cell a1 that says "1234 brown st" and data in cell a2 that
> says "A...$ format within if statement
I am using Microsoft Excel 2000 for a financial spreadsheet.
I want to compare two different financial computations and see which is
higher for each row.
My "if" statement looks like this:
=IF(G8>H8,"Category A is higher by $"&(G8-H8),"Category B is higher
The problem is, sometimes the dollar amounts are showing with three
decimal places, and I only want to show two for dollars.
For example, it may say:
"Category A is higher with $201.098"
How do I get it to show only two decimal places?
Thank you in advance for your h...Conditional Formating based on another cell
I have 2 columns of concern DATE and COST.
I would like the COST cell to be shaded if the DATE cell is less than a
Then if it is possible to calculate the COST field but only the ones
Help is greatly appreciated!!
For the conditional format, use the following for the condition of the cost
and so on, where cell A2 is the corresponding date column. Select the
appropriate shade on the pattern tab.
As far as calculating the cost column if it is highlighted, my only thoughts
are to write a macro that you can run that c...trying to concatenate two columns without removing leading zeros
A customer sent me a spreadsheet in an incorrect format for my
purposes. I have about 13,000 records in Excel 2007 where I need to
concatenate column 1 with column 2 to create the format I really need.
The problem is that each of those columns contains numbers, and when I
do an =a1&a2, if a1 contains 00123 and a2 contains 0121, I end up with
123121 when what I really need is 001230121. I've tried formatting
the cells as text first without any luck. Any help would be greatly
I'm not positive yet, but I *THINK* this may have worked. Let me see
if when I o...if than statement has too many variable
I'm pretty much a novice at using Excel but made a formula a couple
years ago to calculate freight. There are 2 basic scenarios, if the
weight falls between a certain brackets it gets a set price or it gets
multiplied by a percentage. I think the max number of if than
statements is seven... correct? My excel file was corrupted about 3
months back and I have been unsuccessful in recreating it. I'm open to
using a more appropriate formula or fixing the current one. Either way
I appreciate the help.
=IF(E4<=50,28,IF(E4<=305,42,IF(E4<=393,E4*0.1373,IF(E4<=500,54.0...Conditional count 01-25-10
I need to count unique occurances of names in column a which satisfy
conditions in two other columns. For instance:
A B C
Smith faculty annual fund
Smith faculty annual fund
Jones faculty annual fund
Smith faculty new gift
Jones faculty new gift
The number of unique occurances of Smith in column A where column B=faculty
and column C=annual fund. The answer of course is 2, but how do I write a
formula ...Synchronize Outlook 2003 on two computers?
Any way to do this? Searched KB &TechNet, but only got articles on server
Jack Black wrote:
> Any way to do this? Searched KB &TechNet, but only got articles on
> server sync...
Check this page for all you need to know:
Ben M. Schorr, OneNote-MVP
Microsoft OneNote FAQ:
**I apologize but I am unable to respond to direct r...run two queries from one click?
This has to be easier than I'm making it. I have a form with these
TaskID - number
Task Description - text
Month Completed - text list pulled from a query
Year Completed - text list pulled from a query
Category - text list pulled from a query, can be more than one
category per task
Task Description - memo
Now what I want to do is...
insert TaskID, Description, Month Completed, Year Completed and
Description in one table
insert TaskID and each Category into another table with a single
button click to make it easy for users. As stated above, there can be
more than one cate...How to change line chart color based on condition like + and -.
I have a line chart that is somtimes negative and somtimes positive. I would
like the line when negative to be red and when positive to be black or blue
or green. Is there a conditional format procedure for line charts?
This may help
Andy Pope, Microsoft MVP - Excel
"egii" <firstname.lastname@example.org> wrote in message
>I have a line chart that is somtimes negative and somtimes positive. I
> li...WHAT IS THE FORMULA TO CALCULATE HOURS BETWEEN TWO TIMES
i want to calculate with the help of excel worksheet the hour worked by an
employee if his in and out timings are given. for example if ones in time is
say 9.30am and his out time is 6.42pm what is the total hours worked by him.
to find out this what is the formula used?
Just subtract and format as time. If you need hours in order to calculate pay,
it's =(B1-A1)*24*C1 where start time is in A1, end time in B1, hourly rate in
On Mon, 27 Sep 2004 14:13:05 -0700, "babu" <email@example.com>
>i want to calculate with the help of excel workshee..."Money's balance disagrees with statement balance"
When I go to reconcile my credit union checking statement each of the
last several months with my money account, the starting balance is not
what I entered the previous month from my paper statement. When I
change it to what the paper statement says, I get a warning. I ignore
the warning, enter the statement ending balance, and the account
always reconciles to 0 discrepancy. But then next month, the previous
ending balance gets changed when I go to reconcile the new month and I
again have to correct.
This started a few months ago. Never had a problem before and I don't
think I chan...If Statement with And and Or
I wrote the following calculation on a form and it does work, however, I know
that it can be combined. I have been trying, but no matter how I combine
them I keep getting errors.
Here is what I have without combining the last two IIfs.
=IIf(([txtBannerType]="Standard" And [txtPaperType]="Large Format Bright
White (#24)"),[lngCount]*5,IIf(([txtBannerType]="Customized" And
[txtPaperType]="Large Format Bright White
Continuo...Need help making chart using data from two columns? Elementary....
Hi, This is prabobally very simple I guess, but I can't
figure out how to get it to work.... I was trying to make
a chart that would use data from two columns.. more less
One column "A" let's say has names of people who bought
something JACK, JOHN, JEFF etc...
SECOND column "B" has how much they each spent next to
their name so whatever $1, $2, $15 etc...
Now the names will repeat with some other $.... of who
So this is what I would like the chart to do...
Check column "A" find all the JACK's and SUM what he
I need help I want to do the following thing in excel
If i have to make condition for the selected cell that if any perticular
cell is equal to something the selected cell should have some color,
please let me know how i can do this?
Just copy and paste the below formula in any of the cell
Now place the cursor on the pasted cell and drag it for the remaining cells.
Copy that cell and paste it for the remaining cells.
If th...Price Lists
I think I know what the answer is going to be.
Our retail arm sells all products at 100% of list price; the item price
lists are set up accordingly. However we'd like to have a price level of
cost+0%, which we can use to sell items to certain wholesale divisions of our
It doesn't look like I can assign two price levels having different price
methods to the same item. Am I right?
Our list price includes GST and markup, so figuring cost backwards from list
will always be a two step process (in case anyone was about to suggest that).
Am I missing something?
You can set...Help: Joining Two subroutines
Pardon me this is my first week learning VBA . I have two excel
sub-routines each working independently , how can i link them so that i
can insert them to the same sheet module .
End Sub Sub
Message posted from http://www.ExcelForum.com/
Not sure what you mean byu "Joining", but running C will run A, then B.
This is how the code should appear in your module:
MsgBox "Hi from A"
MsgBox "Hi from B"
MsgBox "Hi from C"
MS Excel MVP
"kankel...how do I condense a two page letter to one page
what is the procedure to use when a letter spills over onto a second page and
you want make it fit onto one page?
Decrease the margins?
Make the fonts smaller?
Edit out some of the content?
Wave a magic wand?
"staples" <firstname.lastname@example.org> wrote in message
: what is the procedure to use when a letter spills over onto a second page
: you want make it fit onto one page?
To fit more text on the page:
* Make your margins smaller so the text area is larger
* Use a smaller font
* T...Multiple nested if statements
I have a list of 10 possible categories of debt, i.e:
A 0 - 100
B 101 - 200
C 201 - 300
D 301 - 400
E 401 - 500 etc.
I also have a list of debts, by invoice, with varying amounts, i.e:
Invoice 1 $159
Invoice 2 $345
Invoice 3 $677
Against the invoice I want to add the category it falls into, i.e A,B,C etc.
Because there are 10 categories there are too many to use =if(.... how can I
With an invoice in C5 try:
In Perth, the ancient capital of Scotland
and the crowning place of kings
...conditional formatting within chart
I've got a bar chart (the lines flow left to right) that i update every
week...the current bar chart i'm using has some sort of conditional
formatting where if the number is >0, the bars are all green, but if the
number is <0, then all the bars are red...for some reason my original chart's
formatting stopped working. how do i set that up, short of highlighting each
bar...i've got about 20 graphs to update...
The way that I would do it is to have two sets of helper columns, one with
the negatives and one with the positives, like so
=(IF(H1<0,ABS(H...Two columns one stacked
I am trying to create a chart that has three pieces of data (one objective
and two actuals) and have them combined into two columns for specific areas.
I'd like the objective to be one color and the actuals to be a stack of the
two sets of actuals to show the detail between the two. I have been
unsuccessful in creating such a chart. I'm not sure if this is even possible.
I'm using Excel 2003.
See the second example at
Bernard V Liengme
remove caps from email
"ir...Synchronize two combo boxes on a form
I'm using Sql 2000 and Access 2003. I'm using the code below that's from
Article ID 289670.
Me.Department.RowSource = "SELECT Departments FROM" & _
" Department WHERE BranchId = " & Me.Branch & _
" ORDER BY Departments"
Me.Department = Me.Department.ItemData(0)
I got the code to work but I had to copy and rename my tables to Department
and Branch. My original tables were named with tbl. My combo boxes were named
with cbo but I had to rename them.
I've tried everything to get the code to work with the tbl and c...overlay two graphs with different x axis
hi there i'm having trouble trying to overlay 2 graphs together, the
are shown below.
the data used is shown here:
for the cost graph, it is a standard line graph: y axis is I9:I24,
axis is K9:K24
for the phase graph, it is a stacked column graph with a hidden dat
series: y axis is stacked K3:K6 and L3:L6, and the x axis is G3:G6
is it possible to overlay these gra...IIF statement to run a Macro?
In a Form, I want to run a Macro if a specific condition is met. Does
anyone know how to do this? I tried a Command button but it does not
have th Control source line to enter an expression. I tried a bund
text box which allows IIF statements but if the condition is met, I do
not see how to run my macro.
Thanks in advance,
Run the macro at all times. Use a Condition in the macro to test whether to
stop the macro (first step action in the macro).
<MS ACCESS MVP>
"BillH" <email@example.com> wrote in message