I have seen many threads about the stop watch but have problem to figure out which one will be best for me. I would like to create the stopwatch in excel where I can time single athlete (unlimited number) and check their splits/laps as well to get their total time. I would like to be able to take as many splits I want it. I need this to work in seconds.
AthleteSplit 1Split 2Split 3 Split 4Split 7Split 8Split 9TotalMichalGreg
Can we use excel as a stop watch, with pause and continue menu? We are going to have a mini basketball tournament and I was assigned to be a timer. I want to impress my friend by using excel as a timer.
View 10 Replies View RelatedI wanna know what is the function for the sport competition excel files, such as the EURO 2008 excel file.
Thw function I want to know is how to define winner of a match and the winner go to next round.
Maybe example like this:
Man Utd 1
Real Madrid 0
Juventus 2
Arsenal 3
In that when Man Utd and Arsenal won they automatically appear in the cell for next round and their cell with score is having bold properties.
I’m trying to make a workbook for sport results.
What I want is a means of entering up to 12 results by date.
I’m thinking on the lines of :
12 combo boxes with the teams.
24 combo boxes to select the result.
A calendar to select the date of the match.
A command button to enter all the results to a separate workbook.
At this point I’m not even sure about doing this on a user form or with embed controls… I’d prefer the embed controls but then again I’m all but excel useless!
So if you can picture the following as controls you’ll hopefully have an idea of what I’m writing about!
Combobox for Team 1 Combobox for Score (1-10) V Combobox forTeam 2 Combobox for (Score 1-10)
Through to the last
Combobox for Team 23 Combobox for Score (1-10) V Combobox forTeam 24 Combobox for (Score 1-10)
1 x Calendar to select dates.
1 x Command button to enter the teams, result and date on to a separate worksheet.
I am creating an hourly schedule (for a calendar year) that shows rental space occupied by 4 different groups (baseball, softball, soccer and football). I have created worksheets for each group and am entering proper names. I want to be able to search the worksheets for ANY text and return a value to a master sheet based on the group they belong to. If the cell is empty I want it to remain empty in the master sheet. Example: Ed Jones is entered in sheet 1, cell a15, and will show as "Baseball" on the master sheet cell a15, Mary Smith is entered in sheet 2, cell b16, and will show as Softball on the master sheet, cell b16, etc. The sheets are divided out into sports fields that they can rent. Multiple sports can rent the same fields so it is important that my master sheet show who is renting the field that day so it can be set up properly and they don't get double booked.
View 5 Replies View RelatedI want to write a Formula or Macro :
To clear Second Leg score in First Leg of Cup match
in Attached file, I explained detailed what to do. [URL]
if u need to know anything about Football,
I'm debugging a file that keeps crashing. Every time it crashes I have to reenter about 6 different watches in my VBE Watch Window. Is there any way to have my Workbook_Open() create the watches?
View 14 Replies View RelatedI'm trying to write a macro that will watch to see if there is change in a range of cells, and if the values of the cells change to preform a given action. I need to do it this way because I can't put a formula in some cells.
View 8 Replies View RelatedI'm in the process of writing/editing a macro, but after I run the macro once, the Expressions in the Locals Watch window disappear, and if I try to run it again it produces an "Excel has encountered an error and needs to close". The macro probably doesn't make much sense out-of-context, but perhaps there's a glaring error that's causing this. A guess - possibly related to the Error Handling in the vba? (1st time I've used this in a macro).
Option Explicit
Sub Compare()
Dim strNaspK As String
Dim strCtryK As String
Dim intCtryRev As Integer
Do Until ActiveCell. Offset(1, 0) = ""
ActiveCell.Offset(1, 0).Select
strNaspK = ActiveCell
strCtryK = ActiveCell.Offset(0, 2)
On Error Goto ErrJump:........................
Basically, I've got two sets of data on different sheets, with NASP ID and country being variables. Just trying to import the data from the 'Comparison' sheet, if both the NASP id and country matches that on the first sheet, established by the variables.
I have a collection with several thousand items. I added the collection to the Watch Window in the VBE editor, but the Watch Window only displays the first 256 items in the collection. Is it possible to view all items of a collection in the Watch Window?
View 3 Replies View Relatedmy excel sheet runs through a lot of calculations, opens Flowmaster, a simulations program, passes on data, receivs data and so on. Is there any way to have a user input to stop the whole simulation. During the first tries I had a lot of break point in my debugger. But now I want to have a button to hit or better just some keys to hit to stop it without using the ctrl+alt+del which closes everything.
View 4 Replies View RelatedI have a report which has a list of customers, each customer has 24 columns which represent the payment history over 24 months. If a payment has been made for that month the date and time (formatted correctly) will be populated in this cell.
Each customer has a product name attached to it so a product can appear several times. I need is a formula that shows the total payments recieved for a particular month for a particular product. For example.
I have managed to create the following flag which works a treat, it picks up a date an account was set up but looks at 1 column.
This may not be the best way to do this, but I don't know Macros or Pivot Tables.
I am looking for a way with formulas to do the following:
Within a workbook the 1st sheet is the data entry.
In another sheet that will total data from the data sheet is where I want to be able to total columns of data, depending on what is entered in one specific column:
Example:
Data Sheet, E2:E2999 is a unit number selcted by pull down tab entry.
G2:G2999 in the same sheet is where the data is.
Q: What formula would allow to total the data on the Total Sheet depending on what unit number is selected in column E on the Data Sheet and the data amount in column D from Data Sheet?
I need to set up an easy to use spread sheet for my office. It needs to be able to calculate the running total spent of fuel, as well as include any discounts we get and then calculate our total savings.So basically, total spent and total saved.
View 3 Replies View RelatedI'm sure this can be done but I don't think I have the formula correct. What I am trying to do is add each day's total while displaying a positive number if the total exceeds 6000.
View 5 Replies View Relatednumber for item detail level from category standpoint. For example, in the category sheet has total number per category and per month and in the item detail sheet has a list of item number with category. I want a formula to recognize which item belongs to which category then use the total number of category by month to multiply with % of total in column D from Item Detail Spreadsheet.
View 2 Replies View RelatedI am trying to create a very basic workbook that has 2 worksheets. one is a daily input for tonnes, that then just gets cut and pasted to a different program, and the other worksheet is the running total. i.e., it adds up every time you update it.
been trying to figure out a macro so when you press the update button it then just updates the monthly total.
Colac Production.xls
In an excel work shift schedule, I am trying to total the total number of days someone is scheduled for different shifts. I can get a total for the current schedule but I want to be able to have a year to date total as each new schedule is added in. These totals are in the AF through BC columns in the xray shift totals in the attached worksheet.
I don't know if it is possible or not and am working on a pre-existing worksheet.
Sub sumbotton()
Dim ar As Range
Dim rng As Range
Set rng = Selection.CurrentRegion
Set rng = rng.Resize(rng.Rows.Count + 1)
rng.Rows(rng.Rows.Count).Select
For Each ar In rng.Areas
ar.Resize(1).Offset(ar.Rows.Count) = "=SUM(" & ar.Address & ")"
Next ar
End Sub
I have a sheet in my workbook with at least 180 small tables, there may be more.
I woulds like to be able to change total formulas for all tables at once to show either year-to- date or total year.
For example:
If we have only progressed through the second period of the year, I would like to choose something to indicate period 2. At other time I may want to know the total year whether the periods are completed or not.
I have a column with Cells that will sat True or False, the amount of rows will be different every time, I need to work out what the total percentage of True cells compared to the total number of cells. How would this be achieved.
View 9 Replies View RelatedI have the following formula: ....
View 9 Replies View Relatedi need to make a button that Immidiately stops all macro's, Or (and This will maby be little more difficult) Stop all macros on a specific time inserted in 1 cell
the macro's that i want to stop running, are all single macro's which i activate with only 1 button i created.
i like something like this:
if "A1"(this is the cell where i have my updated clock) == A2 (the time i insert here stops the macro's at this time) do stop Macro's
All I want to do is to stop a routine when I press the Cancel key on the user form that the routine called. I have tried "stop", "quit", "end", "abort", et. al. This seems so simple but I cannot figure out how to do it.
View 7 Replies View RelatedIf you run it now, ctrl t, it produces letters and changes alphabets as it hits a yellow box. If i change or add a yellow box, the letters change fine. The macro works perfectly, but instead of inputting the range or K3 to what ever, i would like to to run this macro and stop once it sees the row with the sort number of 4. ( this changes row postion depending on which sheet im working on, this is the problem).
View 4 Replies View RelatedI'm trying to use the find function to make my macros easier to handle, but I don't know how to run through all instances of what I'm trying to find and then stop. Currently I just have my find function in an infinite loop and it stops when it runs into an error. This works well I guess, but I'd like to know how to stop after the last instance without error. Here's the code that I have been using:
View 4 Replies View RelatedOption Explicit
Private Sub UserForm_Initialize()
lblCloseProgress1.BackColor = &H8000000F
lblCloseProgress2.BackColor = &H8000000F
lblCloseProgress3.BackColor = &H8000000F
lblCloseProgress4.BackColor = &H8000000F
lblCloseProgress5.BackColor = &H8000000F
End Sub......................................
Each of the timdown procedures adds another segment to the countdown clock (if you don't click "Exit" before the five seconds are up, the file closes without saving. All well and good.
Now, if you DO click the "Exit" button, you get a message that the close has been aborted and, upon clearing that messagebox, the file closes anyway!
I think it's something to do with killing all remaining OnTime instructions but I don't know how to go about stopping the clock.
I have an Excel add-in that makes use of an Application-level event handler to detect when workbooks are activated / deactivated, and adjusts the command bars / ribbon accordingly. The add-in also includes a developer mode, so I have a shortcut key to stop the add-in while running, set the .IsAddIn property =False, and then change whatever settings I feel that I need to.
Problem is, when I run the shortcut to stop the add-in, and then run my shortcut to restart it, my event handling no longer works. I've done some MsgBox testing, and verified that the class module's "Initialize" event gets called, but subsequent events (i.e. WorkbookActivate) go unnoticed.
I'm wondering if Excel will allow me to start an Application event handler using WithEvents, stop it (by setting the class module variable = Nothing), and then re-start the event handling.
I have made a sheet that contains a formula that links to another page and until I have a number in that cell the cell with the formula says NA is there a way I can clear that so it wil be a blank cell until I put a number in.
View 9 Replies View RelatedI wrote a code that when a change is made to a sheet the "=today()" formula is inserted to cell A for that row. My problem is that my spreadsheet keeps freezing whenever I insert a new row. Is there a code to stop running the code if a new row is inserted? Below is the only thing I have so far.
Private Sub Worksheet_Change(ByVal Target As Range)
Application. ScreenUpdating = False
With Cells(Target.Row, 1)
.Value = "=today()"
End With
End Sub