vba array

I have a worksheet which collects data for football matches and I want to filter for 2 text strings, but eliminate 2 others. I had previously just used autofilter with 2 criteria to produce anything beginning with LTD or MARIA1, but it just gives too many results which also end with CSP or BTD...

Dear All Master, It should be in column B in the "recon" sheet which I mark yellow but I use the vba code below but the result is in column G in the sheet "recon" which I mark red. There may be something wrong in the code I edited below and I just added a little or modified it a little without...

Dear All Master, I want the formula in the T & U column to be a vba array and dictonary code so that it becomes faster and please also add a comment matrix in the code so it's easy to understand. Thanks roykana DESIRED RESULT ABCDEFGHIJKLMNOPQRSTU1No TransactionDateDept.Code Pel.Name...

Dear all master, so I want to import dat files to excel only for specific data or criteria that I want. So the data from the dat files is directly imported according to the criteria I want. The criteria I want are those starting from "2019-12-21". But I want the filter from the criteria to be...

Dear all Master, below I want the desired result in column E which I marked in yellow and also I use a formula so it's easy to understand what I mean and I want to add a little in the code below without changing the structure of the code below and I also made a vba code for in column E in sheet...

Dear All master, I want if I make changes in the "master" sheet it automatically changes in the "trans" sheet. I want a fast code because there are thousands of records in the "trans" sheet. ABCDEFGHIJ1Supplier NameCODENEW CODECOMBINEITEM DESCNEW PRICEIsiUNIT IN ACTUALPriceUNIT IN...

Dear all master, I want a fast code sumif vba array and dictionary because there are three hundred thousand records. I've also made the sumif vba array and dictionary code but it only works for 1 column and 1 criteria results. Please help for the solution. sheet name "OPS" with table name "OPS"...

Hello, I have this code that reads a Text file and puts some data in an array and writes it to the sheet. I am having issues with safety inspection and obd inspection arrays as sometimes the whole line is missing in the text file. I was wondering how can I handle the error mismatch when writing...

Dear All Master, I want to change the formula to vba array and dictionary because there are 350000 records and I also use add custom columns in power query so excel formulas don't run automatically so my solution is to use vba. for information my sheet name is "GSG" and my table name is...

Dear all master, please help for the problem in the VBA dictionary does not appear because the source is text and the result is a number which I marked in yellow and the other results appear because the source is text Sub Demo0301() Dim Rng As Range, Ds As Range, n As Long, Dic As Object...

Dear All master, With this, my vba code to import image filenames with an open dialog box can import filenames from folders or subfolders to my excel table. For the id column, what I mean is before the "-" & "(" sign, then it is included in the id column. For filename originating from that...

Hello! I'm using the below code to reorder my worksheet's columns based on a predetermined column order. This code works as long as there are less than 500k rows, but once the number of rows exceeds 500k, I receive an application-defined or object-defined error. Is this code limited by memory...

Dear all master, I want very fast vba scripting code and array vba code to import or read data in a folder or sub folder containing excel files. There are 500-600 excel files. I want some excel files that I have marked yellow or only have outstanding values to appear in the excel result file...

Dear All Master, I want help modifying my vba code below because it is still slow and the row record is above 200000 and also a problem with the results if the table data in the "eg" sheet is filtered then the result is wrong so I want a very fast vba array code . So there are 2 process...

Dear All master, I want to connect with multi data source for dbf file with vba array code. what I want is the following: 1. Modify the connection string according to the dbase file provider 2. Can I connect with my multi DSN reference and become one sheet Data Source Name DefaultDir FILE NAME...

Hi, As title suggests, I'm using an array for data consolidation. I keep erroring when trying to copy columns with any formulas in them... is there any way around this when using this method ? I would also really like to ignore blanks cells & not bring them into the array. Sub Arraycol()...

Dear all master, Please help for vba array code remove numbers based on specific contents of cell. ORIIGINAL RESULT So remove the numbers based on the contents of the word "KANA". Thanks roykana

Dear All master, Please help me to make code vba array and the result match as in the result sheet. LINK https://drive.google.com/file/d/12z10pcR3YVgzhpCfGErtGdrFzYrnpCtk/view?usp=sharing Thanks Roykana

Dear all master, Please help me to code vba array so the result is not formula. Set rng1 = TargetSheet.Range("G2") Range("G1").Value = "REMARK" Range("E1").Value = "D/C" Range("H1").Value = "REMARKHELP" Range("I1").Value = "REMARKFIX" With TargetSheet rng1.FormulaR1C1 =...

Dear All master, Please help me to make vba code. What I want in the bca sheet in column B which only contains "KR AUTOMATIC LLG" then the numbers are removed and I have marked yellow. LINK https://drive.google.com/file/d/1iok21UA86tH0KMTyTRMqiBYoCSukJfYw/view?usp=sharing Thanks roykana...