Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying worksheets with formulas in hidden columns | Excel Worksheet Functions | |||
Excluding formulas in hidden cells? | Excel Worksheet Functions | |||
How do I avoid referencing hidden values in formulas like OFFSET? | Excel Worksheet Functions | |||
Hidden rows unhide themselves when formulas are written | Excel Discussion (Misc queries) | |||
Protection UserInterfaceOnly reading Hidden Formulas | Excel Programming |