events

  1. M

    Converting list to table

    Hi all, I have the following set of data: <colgroup><col><col span="2"></colgroup><tbody> Name Event Place Athlete 1 A 1st Athlete 1 C 1st Athlete 1 D 1st Athlete 1 E 1st Athlete 2 C 2nd Athlete 2 D 2nd Athlete 3 A 2nd Athlete 4 E 2nd Athlete 4 F 1st Athlete 5 B 1st...
  2. D

    Help Please. How to keep a running total from multible events.

    I want to keep a running total of Points, Events, and Cashes from 40 events. The players will vary from each event. And the list of players in the "Total Table" will grow. Also the Player "Rank" will be resorted after every event. I'm still a beginner, and learning as I go. What am I missing...
  3. M

    Target.Address

    I found this code on the internet which works when dealing with one individual cell however stops working when values are pasted in to multiple cells at once. Can anyone help? Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$I$3" Then 'disable events...
  4. D

    XY (Scatter) Chart Question | Key Events for Project 1.1

    Hello Mr. Excel Masters! I create a chart to visualize "Key Events for a Project" based in a XY (Scatter) Chart. There is a way that Horizontal Axis reflect the dates entered for the chart? I mean, Each milestone date show on the axis instead of a range of time? Link to Template download...
  5. R

    Conditional Formatting based on VLOOKUP

    I need help conditionally formatting cells based upon the text found in a VLOOKUP - I am creating a calendar that references background data to automatically populate events based on their dates. We are also looking to color the events based upon different criteria (i.e. different teams...
  6. N

    Application.EnableEvents not working on a second workbook

    Hi All - I wrote a sub that copies certain formulas from one workbook to another blank workbook. I've set Application.EnableEvents to false - this seems to work fine if I'm copying code to another sheet in the same workbook, but if I'm copying to another workbook, events are triggered and I...
  7. T

    Forcing File Name with xlDialogSaveAs.Show?

    I have a macro (simplified it here) that performs many activities, but then presents the User with the Save As Dialog Box to save the file. Once the file is saved, additional steps happen. I wanted a method to stop the Macro if the User Canceled the Save As because if not, the current form...
  8. J

    Comparing values within a named range

    Hi, I am learning about named ranges. I have a set of records that provides information about when an event starts and ends. There are multiple events that occur within a day. I need to determine what the delay was between each event. See the table below for an example. The named ranges are...
  9. T

    Macro that when I select a name it pulls that clients data into a form like tab

    Hi everyone, I have a tab that's set up to make it easy to input data which is then moved to the "Events" tab as a list I want to be able to pull the data back from the "Events" tab into the "Form" tab so more data can be added it can be edited etc. So what I'd like is a way to run a macro...
  10. B

    Charting occurrences over varying time periods

    I have Office 2007 running on Windows 7 Pro (64 bit) SP1. Hopefully someone can help with how to create a chart for a spreadsheet I am setting up. The spreadsheet has only two columns: Dates in Column A, and Events (1, 2, 3, etc.) on that date in Column B. My dates run from the year 2012 thru...
  11. L

    different ID numbers in the same column

    Hi there, I want to log ID numbers for two types of events: educational events (E0001, E0002, E0003.....and so on ) and non-educational events (NE0001, NE0002, NE0003.....and so on )), such that I would have a list that shows both in the same column in the following manner: E0001, E0002...
  12. S

    Non-Overlap Time of Events

    Hi folks, I have been having problem with some overlapping events and I hope I can find a solution here maybe a guru helps: I would like to calculate each even’ts non-overlap minutes from a time series of downtime events. A generic formula supposed to work for any duration of a time event...
  13. J

    HTML Dropdown List - No 'Options' or 'Selected' or 'SelectedIndex'

    Hi All I am trying to automate running a query on a website by inputing/select multiple parameters. One of the parameters is to select an option from a dropdown list. However, when browsing through the dropdown object's properties (HTMLInputElement) in VBA editor's Local window, I can't...
  14. A

    Unique values for specified range

    I have a master sheet with thousands of rows. This sheet is basically the mother sheet where other sheets will be taking their data from. Let's take the following mother table for example: Now I have another sheet which is exclusively for musical events. The table looks like this...
  15. A

    Forumla to extract information

    Extract information from main sheet into another sheet microsoft-excel worksheet-function microsoft-excel-2010 microsoft-excel-2007 microsoft-excel-2013 I have an excel sheet that contains a list of events. The main sheet basically has thousands of events of different categories, such as...
  16. M

    Hiding Application Events in Specific Workbook

    Hello Guys, I want to hide Application events like status bar. formula bar in specific file. I tried workbook events also it is affecting other workbooks too. Any other possible solutions? Thank you.
  17. D

    separate events on sheet from events on userform

    Hi, I have userforms that open when I click in a cell - the userform has a listbox with terms to select for the cell. The problem is that if the cell is in the same area that the userform occupies the same click opens the userform and selects a value from the list - how can I avoid this - I...
  18. T

    Calculating percentages for Annual Report

    good morning, i am trying to calculate percentages in excel, i am working on an annual report where the original report is generated for me with the proper percent. I have to remove numbers from the original and create a new percent, i am having trouble creating a new percent.i found that the...
  19. C

    Countifs between Dates with text range

    Hi I'm struggling with a report that i'm wanting to generate. I have been able to report the total number of events between dates (month) using the following: =COUNTIFS(createdon,">=" & C2,createdon,"<=" & EDATE(C2,1)) createdon = set range in data worksheet C2 = Date (e.g 1st Jan 2017)...
  20. S

    VBA code for autosorting ranked row

    Good morning! I am working on a project for the president of our company and am not familiar with VBA code, as I have not had cause to use it until now. I have an excel spreadsheet with 8 participant names, participating in 7 events. Each participant's total of the 7 events is calculated and...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top