excel "multiple strings"

Hello everyone! I know excel well, but I don't know vba. I would be grateful for any help. Based on the table (М-55 МP) i need to use any tool to build a module that, when checking a product line with options, would automatically display its production date. Line to check -...

Hi, It's been a while I have posted a question here, but when I had this issue, first thing came to my mind was 'MrExcel.com' :) Anyways, I use outlook to search multiple items (invoices) and i make use of keywords. let's say I am looking for 3 items, 111236-2, 111235, 111321. Usually the list...

so I have a spreadsheet that has 8 columns. In the first column is a date of 1st payment, the next column is amount of 1st payment, the third column is date of 2nd payment, four column is amount of 2nd payment, The fifth column is date of 3rd payment, six column is amount of 3rd payment, seven...

I'm a little stuck on a project. Sheet 1 has a list of people Sheet 2 has a list of people Sheet 3 needs to compare the lists in Sheets 1 and 2 and list the differences between them. I'm not sure of the syntax, and how to write the indirect formula to do this ? Any help would be greatly...

Hi, I am fairly new to vba and I am trying to copy data from multiple sheets except from sheet names that are in the defaultsheetnames array. DefaultSheetNames = Array("Admin", "QBBOM", "Index", "Master", "Template", "Revision Log", "Instructions", "Sample", "Deleted Items", "ChangeLog"...

Heyy there, My problem is : i cant remove duplicate column by single string I want script or marco or anythink (automation) to fix this problem Take look of screenshot of my solution what i need Thank you every one who fix that :D

Hi Guys, Can someone please help me to correct my VBA code to achieve my requirement please. I have a range of IP using which I want to create a command and I want to do this via macros. The command part will be same every time, only part that will change is IP. So, I'm trying to achieve this...

I have the follow values in a cell: Original Value BlockChain Retweet BlockChain BlockChain:xyz Retweet:abc BlockChain:adc xyz abc adc would like to use excel formula and VBA

how to make VBA copy every cell from a column to a different .bat file. The location and file name are in the excel. For Example: A contain FileName B contains location C has the script for the Batch file A & B are different values. Please help

Hello, I have 4 sheets in a workbook (Sheet1, Sheet2, Sheet3 and Sheet4) On Sheet1 I have a dropdown in B1 to select from a list of fruits. For eg. Apple, Banana, Cantaloupe, Below that dropdown there is a "Store" table with headers Store(A5), Isle(B5), Shelf(C5) On sheets 2,3 and 4, I have...

Hello all, This is a difficult question for me to phrase, but I can provide background: I have 200 properties. I have a Statement of Cash Flows with each property listed with hundreds of GL Codes and amounts. I want to summarize the data in a new table by taking whatever GL Codes I want from...

Hi. My excel sheet looks like this with 100 projects. What I would like to do it 1. Search for Project code 1415 2. Copy all the rows from A21-A29 and paste it in Sheet 2 3. Next search for code 1414 4. Copy all the rows from A9-A20 and paste it in the next available row in Sheet 2 5. Next...

Hi, I would like to optimise my excel spreadsheet Is there a scrips to in one Column according to the name selected from a drop down box an email would automatically be generated and sent to the relevant persons after saving the document (data changed, email trigger to the selected individuals)...

Good day, All I am using this code to look for specific Like value in a column then copy it over to next sheet and then remove the row but when it goes to copy the next row it skips a row and start but the row below Please Help. Much thanks in advance Sub SearchString() Dim c As Range Dim...

Morning all, Apologies, posting this because I could not find appropriate solutions to my problem. Earlier I obtained this particular code from Dante (which I’m immensely thankful for) which helped in generating a message box (when two conditions are met) for my worksheet: Private Sub...

Hello, I'm looking for help in locating and replacing/deleting the following pattern within a string in a cell: "xxx.xxxxx.xxx.xxxxx.xxxxxxxxxxx" where x represents a numerical character i just learned how to use regExp...but can't figure out for the life of me how to tell it to look for the...

Hi, I’m trying to delete a picture within a certain number of highlighted cells. I’m trying to do this in VBA and every suggested code I’ve tried doesn’t work or requires specific cells to be selected however I’m highlighting the cells via ActiveCell.Offset codes. The sort of thing I’m after...

I am looking to make a Macro in VBA that when run: creates a new sheet called "results" after the first sheet (to the right) on the original sheet search Colum B for if any of an array of words is present in a cell if it is to select the row and move it to the sheet called results delete the...

hi i need to find a way to create multiple txt files from an excel, as shown in the picture. In detail i need to create a file txt with the name "sez-A1" and another "sez-A2" and so on. inside the txt i need to have the numbers of the 2 columns x and y from the excel

Hello, Context; I'm very much an amateur when it comes to excel but managed to put the below 2 formulas together from a few forums but its causing my s/s to run incredibly slow. The s/s is also web linked to an intranet form which could be causing some of the delay also. The form is a...