1. B

    Wild Card in SUMPRODUCT formula search

    =SUMPRODUCT(--('2019 Sales'!$CR$1:$CR$1055<>"IND")*--('2019 Sales'!$D$1:$D$1055=$A$2)*--('2019 Sales'!$B$16:$BY$16=BX$1)*--('2019 Sales'!$B$17:$BY$17=$A3),'2019 Sales'!$B$1:$BY$1055) Using the above SUMPRODUCT formula - where I have "IND" aim is to sum everything excluding any matches to IND...
  2. D

    wild card date

    How do I use vba to refer to a sheet with a date of "july xxxx"? The x is in place of a number. Therefore, it could be july 2018 or july 2019 etc?
  3. P

    How to handle .VIS file name in VBA using wild cards

    Guys - I am trying to open .vis file using wild cards. The wild card is not working for one particular scenario. The below code is working fine if the File Name is Trial.vis. But, it will not work if the file name is Trial_RE.vis. (However, for .xlsx, it works fine for both the scenarios)...
  4. M

    Highlighting "?" in a whole sheet.

    I want to condtionally format my sheet so that cells containing ? would get highlights. But when i select highlights cells containing ? in the conditional formatting, Whole Sheet gets highlighted. I though maybe its Wild character and tried "?" & '?'. But Not working. Thanks in Advance.
  5. S

    Wild Card in VBA??

    Hi I am importing a report, however sometimes there is a large space within the heading, eg..."Account_Number ", sometimes there isn't, eg..."Account_Number" Rather than having to change the code every time to accommodate this space, is there a wild card I can use in VBA? Hope...
  6. N

    Vlookup text with wildcards into text ranges

    Dear Excel Expert, I been searching for Vlookup function in google for the partial text with a wild cards but it always give me the formula looking for a partial text looking up into ranges with wild cards. My question is vice versa. Example I need to Vlookup the certain text with wild card...
  7. Solola

    Wildcard not returning blank fields

    I swear I've never had this problem before, but now I am (maybe I was just never previously aware that I wasn't getting the data I thought I was getting): I have a query that prompts the user to enter text to be used as criteria: Like "*" & [Enter Supplier Name] & "*" I used to think that...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...