View Single Post
  #13  
Old 3rd January 2005, 10:26 PM
puntz
Guest
 
Posts: n/a
Exclamation

How's this for an idea, this thread can continue with these type of spreadsheet tips. The advantage is it may possibly stay tuned to racing, or just mostly what's commong around here,sports and numbers, right ?!,
Point is, lets say a discussion gets going, and most have their own version of things in a spreadsheet, but there is no common ground, or a common platform to experiment with....
So, let's say Shaun's example, that very formula is used for a number crunch.
Let's say then those that participate have excel, and what's always common with these things, the tedious tasks.
So then the solution would be to "employ" the same name experimental file, same name sheets,and when sheets need to be cleared, just learn to paste a universal macro from here. It's harmless, it simply clears the sheets upon any topic of discussion at the time.
My version of clearing sheets by macro is: (contribution)

'+++++++++++++++++++++++++++++++++
'CLEAR SHEETOING ++
Sheets("SORT1").Select '+
Cells.Select '+
Application.CutCopyMode = False '+
Selection.Delete Shift:=xlUp '+
Range("A1").Select '+
'CLEAR SHEETONE '+
'CLEAR SHEETOING '+
Sheets("SORT2").Select '+
Cells.Select '+
Application.CutCopyMode = False '+
Selection.Delete Shift:=xlUp '+
Range("A1").Select '+
'CLEAR SHEETONE ++
'++++++++++++++++++++++++++++++++
See !!
there is no need to have a diverse array of lingo's when trying to explain something.
SORT1 and SORT2 are just examples,a start.
Two clean sheets in excel with a macro to clear numbers and get on with the next task when trying to explain, in particular, horse racing number crunch issues,in a way it's understood, here.
It may avoid having to RTFM's ,( Help-less files) and may even possibly avoid end up becoming a rocket scientists !, when all ya wanna do is put a bet on !


Perhaps the icons can be avoided to, somehow.
Reply With Quote