wildcard

Hi everyone, I am trying to copy some data from an open file. I have some code, works great but i'd like to make it work for different file names. The "Supplier_report.csv" file is folowed by a date (like Supplier_report_211215.csv ), I always need tot remove it manually in order for the macro...

Hi everyone! I really need some help on VBA pivot filtering. I am trying to exclude "1099" and " *Address* " from a pivot filter called "Vendor_site_code". Also very important, i need to clear all filters before I reapply them. what I have so far works only for the first filter of the pivot...

I am attempting to use the SUMIFS formula in a spreadsheet, particularly on in-state and out of state totals. The codes for out of state will have a 3 digit number followed by a 2 letter state code followed by another two letter client code. So for example, you may see something like this...

Hi, I'm trying to use the index and small functions (from a formula i found online) to search a list of text and return any values that have a partial match. E.g. I search for "book" and it returns a corresponding number for "antique books", "assembling of books", "book publishing" etc. The...

Hello all, I have taken a survey. All my responses are in Column A. I would like to be able to search through those responses and see if they contain a word. If it does, I want to return that cell. So, let's say my search cell (B2) is "bad". I'm looking for a formula to return every comment...

Hey guys, I got a job to categorise the Job titles in our CRM database into 3 tiers and a negative tier (for lead grading purposes). A previous colleague started building up a ruleset which uses keywords to get a certain job title into category: Tier 1, Tier 2, Tier 3 or Negative Tier Now this...

I'm having an issue when I try and compare two cell values. For example my code looks like if Range("B3").value = Range("B4").value then do something Else do something else So in this case Range("B3").value = "1501-23" and Range("B4").value="1501-23 " it looks like it would work but it...

I have a formula as follows (adapted from a post on this fabulous forum) =SUMPRODUCT(--(LEFT('[Sales Current Week.xlsm]2014 Retail'!$C$145:$C$196, 5)="13**2"), '[Sales Current Week.xlsm]2014 Retail'!AE145:AE196) What I'd like it to do is sum sales in column AE in which the corresponding SKUs...

Trying to make a macro to open a .pdf file whose file name contains the selected "Item number" in a spreadsheet. It will open in Internet Explorer. I'm getting close, I can open a file if its entire file name is the item number: Sub OpenPDF() Application.DisplayAlerts = False...

Hello, I have code that will open up a couple thousand excel files over the years one at a time and run some code. However, the extension has changed over the years. I was wondering is there a way to have excel open up all the different file types with variable file names. My guess so far is...

I have two columns from 2 worksheets. In the first worksheet a column contains a list of project names that is active. The second worksheet contains just a list of ptoject names. I need to compare the project names from the first worksheet and highlight a cell if its value does match with...

I've been trying to figure this out but I need help! I want to associate the type of school, based on their email address. My first sheet has a list of email address. I have another sheet with a list of domains and what type of school it is. Is there a way that I can do some kind of a...

Hi all, I am trying to find a way to incorporate wildcards into a number of formulas in Excel 2010 if possible. Basically I have a sheet called "Raw Sales Data" which contains all sales of all items, and on another sheet called "Sales Ledger" I use various formulas to count how many sales...

I have data in one sheet where the headings and data looks like: <tbody> ID NAME FACTION QUALITY TYPE LEVEL MIGHT ROW 1 ROW 2 ROW 3 ROW 4 ROW 5 496833504 Miraculous Throne of Atlas +18 fey 6 chair 18 180015000 173% Attack 357% Load 523% Attack 699% Attack 905% Load </tbody> Currently there...

I'd like to automate creating an Excel spreadsheet built by several files (stored in different sheets), including a daily export file in CSV format. My problem is that this CSV file has date as a part of its name (all other files are named without any changing parts), e.g. REPORT_20150216.csv...

I have a string in cell AU3: E50C [cell is formatted to 'text'] (this value is different for other cells E100B, E110 TH, E20 Y etc.) I simply want to find next LETTER after second position in string (to miss the consistent "E") and split the string at this point, returning the left...

So I've been messing around with a code that opens another file in the same folder as my sheet. I was wondering if it was possible to use a wildcard when opening the file. This is the code I'm using, it's been stitched together from other things I've seen online so I'm not going to say I'm any...

I am building somewhat of a rudimentary search engine that looks for a name, address or unique identifier, using an Index Match formula that searches with a wild card: =INDEX(Name,MATCH("*"&F3&"*",Name,0)) "Name": is the defined name for column C on a separate sheet. F3: is "search field" The...

Hello, I want to copy worksheets from current workbook to a new workbook. The names of Worksheet have format: Name-Month Ex: Adam-Mar, Adam-Apr, John-Mar, John-Apr. Now what I am trying to do is copy all Adam sheets to one workbook and all John Worksheets to another. The code which I...

Hi All, I have a spreadsheet I am writing vba for and I am stumped on my custom sort. I am trying to sort by account name (column E) in a specific order. However, the list of accounts is VERY large so I have been thinking of maybe a helper column referencing another table? A concern I have with...