But when you enter the data in
columns A-C the formulas appear in the cells for the new row of data.

The formulas do not have to be in A-C for there to be a reaction when you
put something in those columns. I think you answered your own question with
the statement above. The formulas are in all the cells to the right of Col
A-C. Something like IF(a0 And b0 And c0, c/(b+c), "") which would give
the percentage of wins to games played.


"Mick" wrote:

About a month ago I wrote a short set of formulas to show a table of
win/losses and % won per session and running totals. Table below:


A B C D E F G H I J
Running Total Session Wins to Reach
Losses Wins % Total % 70% 71% 75%
8/18/2007 575 1329 69.80% 1342 1408 1725
9/1/2007 615 1415 69.70% 126 68.25% 1435 1506 1845
9/2/2007 627 1439 69.65% 36 66.67% 1463 1535 1881
9/3/2007 630 1451 69.73% 15 80.00% 1470 1542 1890
9/16/2007 642 1493 69.93% 54 77.78% 1498 1572 1926

I though I had done it with formulas in cells. The idea was to enter data
in Columns A B C then the formulas would figure out the other columns for
that row. When I went back to update the formulas, I can't find them in the
cells or as a macro for a sheet change. I didn't remember them being set up
with a change sheet macro and or hidden some way. When yo look at the sheet,
the cells and formulas bars are blank. But when you enter the data in
columns A-C the formulas appear in the cells for the new row of data. When
I went to VB there are no macros that I can find that are entering these
formulas.

How can I find these formulas to make changes?
Regards
Mck