Hi
I am in the middle of creating a spreadsheet to record my bets. I use systems to find my bets and have over 100 systems.
I have two options:
1. Use one master page to record all my bets (this will be a large page)
2. Use a seperate sheet (over 100 seperate sheets)
Are there any pros/cons to my options regarding calculation speed and general workbook performence?
Both options would also have summary pages etc within the spreadsheet. Personally option 2 would be easier for me to use regarding creating my summary sheets etc but have no problem using option 1 (it will just take little more headwork )
Cheers
I am in the middle of creating a spreadsheet to record my bets. I use systems to find my bets and have over 100 systems.
I have two options:
1. Use one master page to record all my bets (this will be a large page)
2. Use a seperate sheet (over 100 seperate sheets)
Are there any pros/cons to my options regarding calculation speed and general workbook performence?
Both options would also have summary pages etc within the spreadsheet. Personally option 2 would be easier for me to use regarding creating my summary sheets etc but have no problem using option 1 (it will just take little more headwork )
Cheers