LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default Hidden formulas

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying worksheets with formulas in hidden columns Brian Excel Worksheet Functions 2 August 14th 08 10:03 PM
Excluding formulas in hidden cells? Adam L. Kehl Excel Worksheet Functions 3 April 10th 08 03:35 PM
How do I avoid referencing hidden values in formulas like OFFSET? K Excel Worksheet Functions 2 July 14th 06 08:46 PM
Hidden rows unhide themselves when formulas are written Hongch Excel Discussion (Misc queries) 3 January 19th 06 06:33 PM
Protection UserInterfaceOnly reading Hidden Formulas Rik Ditter Excel Programming 1 July 12th 03 12:50 PM


All times are GMT +1. The time now is 06:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"