1. T

    Way to use type ahead in a validation list?

    Hello, I use a lot of lists in Data Validation. It gets tedious to bring up the list and scroll through until I find the one I want. Is there a way to use type ahead to select the choice without displaying the whole list? Thanks, George Teachman
  2. J

    How do I get a total count?

    I have two products and I need to know how many passed. Is there a way without doing a macro? If so, how? Thanks ahead for any help and suggestions.
  3. sharky12345

    Work out if date is more than 6 days ahead

    I'm using this formula to work out if a date is in the past or future; I need to take it one step further though - can I include if the date in the future is more than 6 days ahead? If it can be done I need it to show "Too Far". Thank you!
  4. M

    Grouping Columns in Pivot Table and use Timeline/Slicer to select group

    Hello there everyone! Im wondering if its possible to do this or not, or maybe some way i can achieve this. What i want to do is make a few groups of a few columns each in a pivot table, and then be able to use a slicer or timeline to be able to select which of the groups i want to see at any...
  5. L

    VBA Popup

    Dear Masters, I have one VBA on Excel that send email to Outlook. Sometimes on Outlook a popup message open. I'd like a VBA on excel that check if Outlook has a Popup click OK if not go ahead. Thanks
  6. M

    VBA to determine next working date excluding holiday List and WeekEnds

    Hello Experts, I have a requirement where i need to update a column in excel with dates thats equal to todays Date + 2 days ahead (Ex: 4-Aug + 2 Days ahead). But the date must not be a weekend (Saturday and Sunday) and also none among the below shown holiday list. Suppose i am running this...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...