wild card

  1. P

    VBA loop with wildcard in Sheet name

    Hi All, I'm pretty new to VBA, this is my also my first time posting on here. Hoping somebody can help me tweak my code; The code loops through all the files in a folder to copy data from a sheet called ("P&L 2019 - UK GAAP") into one workbook. The issue that I'm having is that, a couple of...
  2. E

    Countif not counting

    Ok so let me start off by saying that I know that this is a common problem but none of the common solutions I've tried are working. I will do my best to describe the problem and I am willing to email the spreadsheet to anyone who thinks that they would be able to help. About the Spreadsheet...
  3. Small Paul

    Worksheet Download Random Name - Wildcard?

    Hi All Sorry, I have to ask for a bit of help here. I have a daily report downloaded which gives a worksheet name of 'report123456' but the numbers are randomly generated. In order for my subsequent macro to work, I think I need to either: a) change the worksheet name to 'Data' b) have a way...
  4. L

    Filter a pivot table filter with a wild card

    Hello everyone I`m new here and I have no knowledge regarding VBA (none what so ever) so I apologize in advance... I`ve recorded a macro that looks like this: Sub Team() ' ' Team Macro ' ' ActiveSheet.PivotTables("PivotTable1").PivotFields( _ "[Feature...
  5. I

    Excel index search using a wildcard character (“*”)

    I'm trying to use an INDEX search instead of a VLOOKUP because I want to display all associated cells with one String in a cell. For example, if my String is "Bob", I want to be able to search Column B for all instances of "Bob", and then produce all associated values from Column C. This...
  6. T

    vba Autofilter with wildcard has error .Range("A" & .Rows.Count).AutoFilter Field:=1, Criteria1:="<>" & FundingDivFilter & "*", Operator:=xlAnd

    The Objxl is just a reference to Excel in the MSAccess vba application. The Access - SQL Server application takes data back and forth to Excel. Lots of Remote automation FundingDivFilter is a string variable. The Normal filter is well known. One filter will work if there is a wild card (*) '...
  7. S

    Excel Cube formulas - wildcards

    Hi, I am having trouble finding resources on how to use wildcards in Excel Cube formulas. I use rollup coding for my gl accounts to create my financial statements. So I attach a code to my wage accounts like "WAGES-OPERATING" for my operating fund; and "WAGES-CAPITAL" for wages in my capital...
  8. A

    Wildcards in a Index(Match()) formula

    Hi all, i am working on a spreadsheet with one Sheet of raw data and a second sheet that i would like to have search the raw data, find a first name last name match and then return whatever is in a corresponding cell. i orginally used a Vlookup which worked unless there were any of the same...
  9. M

    Wilcard Vlookup or Index Match

    I have created a fantasy golf sheet to track scores of players and assign points automatically. However, I am running into a problem when during the tournament the player starts on the back nine which adds a "*" next to his name. This changes day to day. The first day he may have an "*" but the...
  10. D

    Wild Card Vlookup Table Array

    I've got a column (I:I) that contains a string of text. I need to lookup a shorter string from a different sheet/table within I2. For instance, I2 = 14FS UL Primary 2015-16. My table (A:B) has A = 14FS UL B = Full. I would like the lookup formula in J2 to bring in "Full". I've tried using...
  11. P

    Index Match Wild Card doesn't work

    Hello! This is my first post, largely out of desperation to leave the office by 5! I have a spreadsheet with a customer name along with other columns of data (as in Table 1). There is also a list of customers whose rows I want to delete from the spreadsheet (Table 2). I placed a column into...
  12. R

    Index Match with wild card help

    I'm working on a project which provides two excel files. The first file, File1, contains a list of SKU descriptions under the header "SKU". They are somewhat long, and contain superfluous information. <tbody> SKU(A1) <tbody> M GEL-CUMULUS 14 M GEL-CUMULUS 15 M GEL-CUMULUS 16 BR W...
  13. S

    Matching against multiple fields

    Hi, I’m working with two address databases where Address1 sheet has the following headings: Property number – Column G for the sake of below example formula Additional Text Add-Text2 Name Name2 Suffix Street – Column I Town – Column K Postcode And the other, Address2 sheet has: Property...
  14. K

    excel query with wild card in parameter

    Hi Good morning everyone. Having a tough time passing a parameter value from a cell into the query. The field I am filtering is a string but I can only query based on the first 12 characters. So I have been trying to use "begins with" or with "like" and wild card characters, without any luck...
  15. S

    Wildcard in Vlook

    I have a huge spreadsheet of contact. I am trying to scrub out all the email address that contain an email extensions on my exclusion list. For example @gmail.com and I am trying to use a wildcard character to find all the email address within my table that cannot be contacted. I am unable to...
  16. T

    INDEX MATCH formula in combination with a wildcard

    Hi all, Since it is my first time using Excel in this manner, I am not sure if Excel is even able to do so, but I have to try because if it works, it will save me a lot of time. I have got three columns (of which one in a different workbook, but I assume that will not be a problem) Column A: a...
  17. J

    if statement help

    I'm using the formula below to populate a cell if another cell does not contain any of the following "R", "0" or is Blank. if the cell "sheet2!G11" has any of those in it the formula cell is left Blank. If the cell contains anything else then it populates with what is in cell "sheet2!D11"...
  18. E

    Wild Card VLOOKUP needed

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif][if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/>...
  19. F

    Keep text matching looping search with wild cards

    Hello! I am trying to write a function that will keep the text matching a search with wild cards. The text in a given cell is structured as follows: Cell A1: 0001: greenlight go, 0002: red car, 0003: monsterblue Cell A2: 0006: pink thing, 0076: applered I now want to search for the word red...
  20. A

    Case - Wild Card search

    Hi, I need to process a column of fleet numbers. If the number starts with CH I need to copy it to one file, if it starts with F copy to another if neither I have to ignore it. Can Excel 2003 handle wild card searching ? Eg. : Case CH* ... Case F* .... Case else .. nothing Regards...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top