Search results

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...

Thanks again, Hui. I might be missing something, but the "Button" under form controls does not link to a cell. Sorry for my ignorance.

Thanks, Hui. First, the "INFLATE" button is round rectangle shape I inserted. Can I link it to a cell without macros? If that is possible, it might just work. Second, I initially just had a formula similar to what you suggested, but I thought that since the budgets I normally construct...

Hi All, I am creating a 5-year budget template and want to incorporate "INFLATE" buttons into the workbook. On the worksheet ("Start") the user would input assumptions including the inflation factor for certain expense categories each year after year 1 (i.e. year 2 = 5%, year 3 = 10%, and so...

I know this is an old post, but I have a follow up question. Can someone let me know how to just copy/paste a range (values and formats) to a new workbook without links? I am getting a VBA run-time error 1004 50% of the time/

Thanks to you both!

Daniel, I am still working on converting it for my use. I am a beginner with VBA, so I am probably not the best at judging technique (yet). I am trying to learn as I go, so it has been slow. I am very hopeful that it will be great. Luckily, the form (Also governmental; SF425) was unlocked...

I went ahead and restarted and it works! Not sure what happened initially, but I am going to try and configure the code for my form. Thanks!

HI Hui, I simply wanted to see his example in action (and see how long it took to perform the task), so I saved and opened his workbook and ran the macro. After several minutes of waiting for "Windows to configure Acrobat 9", it prompts me to restart my system for the configuration to take...

Hi All, Another question. I have a standard PDF form and I am trying to use excel and macros to write the data in excel into the specific fields in PDF. I scoured the internet trying to find the best method (and free!), and it seems like writing the data to an FDF, then using it to fill the...

Hi All, I am sure this question has been posed and answered before, so feel free to post a link. I have a dynamic data validation [=OFFSET(Lists!$C$1,0,0,COUNTA(Lists!$C:$C),1] in cell D4 with a named range (lstAgencies) that refers to a list on a separate sheet. I would like the ability to...