Search results

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

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

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

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

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

HI All, I am having a little problem and need some help from the experts. I have a workbook that contains one tab for data and two additional tabs for reports. Within the report tabs are check boxes. I am trying to create a macro that would allow the user the option to save an individual...

Hi All, I need help! I have a data table and I would like a unique ID# assigned to each new entry based on 3 criteria. I have already constructed the 1st two parts of the ID#, but cannot figure out how to increase the number based on previous entries. Example: First part of ID#...