Recent content by spena129

Luke, I never thanked you for the help. Works like a charm. Thanks a bunch, Steve

Hi All, I am sure this has been asked/solved before, but I cannot seem to figure it out nor can I find the answer in a forum. I am trying to write a macro on a specific worksheet where a cell value will automatically be copied and pasted in another cell if the original cell's result meets a...

Hi Excel geniuses! Is there a way to have the result of a calculation automatically appear in a comment box related to a specific cell. Or by using a message box? I have a few columns (B through H) of financial info on a single worksheet that are part of a monthly financial presentation to...

Incredible, Narayank! This is correct. I was working all afternoon yesterday on the winnings portion. It looks like you were able to rank the players and add "T" afterwards (if applicable)? I am no excel ninja, so I was trying to create an additional column for each rounds' rankings and use...

Took a lot longer than expected manually (which makes me even more excited to figure out how to automate this), but here is a completed sample: https://dl.dropbox.com/u/97042046/Golf%20Tournament_Bet_completed.xlsx I had to add some helper columns to calculate their total score after the 2nd...

Hi Narayank991, Answers to your questions. 1) The purse for the tournament will always come from the web. No calculations on that, but I guess the only other data you would need to collect from the web would be the actual scores of the players (Columns R through U). You could then calculate...

Hi All, I have a little office bet going with a couple of my colleagues centered around the PGA Championship currently being played. The bet: Pick 5 players in the field as your "team". At the end of the tournament, add the total winnings of each player on your team to find the winner of the...

Hi Montrey, I expected the need for helpers. Both people and columns ;) I have used SUMPRODUCT many times before, but my sticking point seems to be counting the names. Thanks!

Luke, I have 220 unique names. Does your formulas require that a specific name be entered ((NameRange=Name)), because that would defeat the purpose of my desire to count all names and find the top 5. I apologize in advance if I misunderstood. Thanks!

Luke, Really appreciate your help. I am going to continue to work on a formula for this, just to see what I can come up with. Any thoughts? I have seen the use of arrays to count the MAX occurrences of text: http://chandoo.org/wp/2011/10/31/using-array-formulas-to-find-count/ In the...

Luke, I have tried a Pivot Table, but I was hoping to be able to have 2 cells set up as date selections for the date range. I am not sure I can do that with a Pivot Table filter, can I?

Hi Experts, I am sure this has been solved before, but I just cannot seem to figure it out on my own, nor can I find exactly what I am looking for in the forum. I am trying to make a simple dashboard with a section that shows the names, number of occurrences, and a sum of values associated...

Thanks everyone. I am an idiot. @Mike86 was right. I didn't have the code in the correct worksheet. Obviously, still a rookie working in VBA.

Nothing happens. This is part of an overall form that individuals would fill out. I was hoping to have the rows hide/show depending on when the user selects cell C18 and inputs a value. Does that answer your question. Where would I add the Application.EnableEvents = True code?

Hi All, For some reason, my macro is not working. Will you please let me know where I am going wrong? I want to hide a few rows if one cell value is over 15k, if it is <=15000, then should show. See my code below: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If...