I am creating a workbook that will track my credit card spending, since we
use our credit card for everything because we get travel points with it, we
also pay it off every month so this works for us. I would like to be able to
see where and how much of our money is being spend. Like I said I have a
workbook I am working on and the first page worked great with the formula I
have but when I copy and paste the formula into other worksheets in the book
it doesn't work, I'm sure I just have to change something.

I will tell you how this workbook operates, I have a worksheet with all my
regular merchants that we use on a regular basis then on another worksheet I
copy and paste the data from my credit card statement in CSV format into
the worksheet, the data takes up 3 columns "A" date, "B" amount spent, "C"
merchant in column "D" I have the merchants in alphabetical order
"E" I have the formula =SUMPRODUCT(('11-16-07 - 12-25-07'!F1:F300="A AND W
RESTAURANT")*('11-16-07 - 12-25-07'!E1:E300)

It works perfect when I copy and paste the formula and change the merchant
name BUT when I create another worksheet to use to paste next months
statement the formula doesn't work, I get all $0.00 in all cells.

What can I change so that this formula will work on every months
worksheet???

Thanks in advance

Take a look at the formula(s) on the new sheet - it may still be referring to
the original sheet. You can change the sheet name globally by using
Find&Replace and choosing the "Look in Formulas" option while on that sheet.

In the formula you've shown, the sheet name is
'11-16-07 - 12-25-07'
Be sure the sheet setups are the same as far as where the data is entered -
that is, that F1:F300 and E1:E300 used for the same thing.


"Just Me" wrote:

I am creating a workbook that will track my credit card spending, since we
use our credit card for everything because we get travel points with it, we
also pay it off every month so this works for us. I would like to be able to
see where and how much of our money is being spend. Like I said I have a
workbook I am working on and the first page worked great with the formula I
have but when I copy and paste the formula into other worksheets in the book
it doesn't work, I'm sure I just have to change something.

I will tell you how this workbook operates, I have a worksheet with all my
regular merchants that we use on a regular basis then on another worksheet I
copy and paste the data from my credit card statement in CSV format into
the worksheet, the data takes up 3 columns "A" date, "B" amount spent, "C"
merchant in column "D" I have the merchants in alphabetical order
"E" I have the formula =SUMPRODUCT(('11-16-07 - 12-25-07'!F1:F300="A AND W
RESTAURANT")*('11-16-07 - 12-25-07'!E1:E300)

It works perfect when I copy and paste the formula and change the merchant
name BUT when I create another worksheet to use to paste next months
statement the formula doesn't work, I get all $0.00 in all cells.

What can I change so that this formula will work on every months
worksheet???

Thanks in advance

Thanks for the help, It's not working for me and it isn't just the changing
od the sheet name. The problem is I don't know anything about Excel except
the very basics.
What I want to make is something I will never be able to do. Is there any
Excel professional out here that do custome workbooks for a fee???



"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Take a look at the formula(s) on the new sheet - it may still be referring
to
the original sheet. You can change the sheet name globally by using
Find&Replace and choosing the "Look in Formulas" option while on that
sheet.

In the formula you've shown, the sheet name is
'11-16-07 - 12-25-07'
Be sure the sheet setups are the same as far as where the data is
entered -
that is, that F1:F300 and E1:E300 used for the same thing.


"Just Me" wrote:

I am creating a workbook that will track my credit card spending, since
we
use our credit card for everything because we get travel points with it,
we
also pay it off every month so this works for us. I would like to be able
to
see where and how much of our money is being spend. Like I said I have a
workbook I am working on and the first page worked great with the formula
I
have but when I copy and paste the formula into other worksheets in the
book
it doesn't work, I'm sure I just have to change something.

I will tell you how this workbook operates, I have a worksheet with all
my
regular merchants that we use on a regular basis then on another
worksheet I
copy and paste the data from my credit card statement in CSV format into
the worksheet, the data takes up 3 columns "A" date, "B" amount spent,
"C"
merchant in column "D" I have the merchants in alphabetical order
"E" I have the formula =SUMPRODUCT(('11-16-07 - 12-25-07'!F1:F300="A AND
W
RESTAURANT")*('11-16-07 - 12-25-07'!E1:E300)

It works perfect when I copy and paste the formula and change the
merchant
name BUT when I create another worksheet to use to paste next months
statement the formula doesn't work, I get all $0.00 in all cells.

What can I change so that this formula will work on every months
worksheet???

Thanks in advance

Actually, I do.

Get in touch via - and while you're at it, go ahead
and attach the workbook in question and I'll see if I can't help you out with
it some. I can at least help with this formula problem gratis, I'm sure.

"Just Me" wrote:



Thanks for the help, It's not working for me and it isn't just the changing
od the sheet name. The problem is I don't know anything about Excel except
the very basics.
What I want to make is something I will never be able to do. Is there any
Excel professional out here that do custome workbooks for a fee???



"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Take a look at the formula(s) on the new sheet - it may still be referring
to
the original sheet. You can change the sheet name globally by using
Find&Replace and choosing the "Look in Formulas" option while on that
sheet.

In the formula you've shown, the sheet name is
'11-16-07 - 12-25-07'
Be sure the sheet setups are the same as far as where the data is
entered -
that is, that F1:F300 and E1:E300 used for the same thing.


"Just Me" wrote:

I am creating a workbook that will track my credit card spending, since
we
use our credit card for everything because we get travel points with it,
we
also pay it off every month so this works for us. I would like to be able
to
see where and how much of our money is being spend. Like I said I have a
workbook I am working on and the first page worked great with the formula
I
have but when I copy and paste the formula into other worksheets in the
book
it doesn't work, I'm sure I just have to change something.

I will tell you how this workbook operates, I have a worksheet with all
my
regular merchants that we use on a regular basis then on another
worksheet I
copy and paste the data from my credit card statement in CSV format into
the worksheet, the data takes up 3 columns "A" date, "B" amount spent,
"C"
merchant in column "D" I have the merchants in alphabetical order
"E" I have the formula =SUMPRODUCT(('11-16-07 - 12-25-07'!F1:F300="A AND
W
RESTAURANT")*('11-16-07 - 12-25-07'!E1:E300)

It works perfect when I copy and paste the formula and change the
merchant
name BUT when I create another worksheet to use to paste next months
statement the formula doesn't work, I get all $0.00 in all cells.

What can I change so that this formula will work on every months
worksheet???

Thanks in advance