wild card

Hi Experts, I found below code in forums while I was looking for way to use wild card to filter. Currently, it works fine but I want to switch the filtered row to A8 instead of A1. With my lack of knowledge, I thought I could change .Columns("A:A") to .Columns("A8:A"). But I get debug.. is...

Hi, I really hope someone can help me make this drop down list. I have a cell that a user will type in a acronym. Cell B1 I have a range of acronyms in a separate tab (about 700 of them). I would like the user to presented with a drop down list of cells within the range that contain those...

Hi if I have 1108000 1104006 1702003 and I want it to be c:\data\1108000.jpg c:\data\1104006.jpg c:\data\1702003.jpg How can I do this? Thank you.

I want to return the relative name from column A in cell B16 if the data set = "ORS". I wrote the following formula and it works fine. =@IF(COUNTIF($B$6:$D$13,"ORS")>1,"Check Call Schedule",INDEX($A$6:$A$13,SUMPRODUCT(($B$6:$D$13="ORS")*(ROW($A$6:$A$13)-ROW($A$5))),)) This Issue: However...

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

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

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

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

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

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 (*) '...

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

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

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

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

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

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

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

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

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

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