find values

Hi All, I have a nicely aligned workbook but there is one small part I am trying to figure out. Our Product unit numbers go from 1-50 however they are all within a string for that product code. I know how to get figures to the left and the right etc but I want to get figures in between certain...

Hello :) I've learned a little bit from you all to at least try and start my own code, but I'm completely lost this time. I have a folder with about 120 text files in there. In a header-named column of each text file there are numerical values. I'm trying to create some code that will open...

Hi everyone, can the code below be modified to search for multiple values? So entering a list of 50 values to delete all rows containing each value? Sub Loop_Example() Dim Firstrow As Long Dim Lastrow As Long Dim Lrow As Long Dim CalcMode As Long Dim ViewMode As Long...

Hi everyone, I'm trying to automate my data organisation process, so what I'm looking for is a macro template with the lines of code I need, but for me to change the names of the files. So, what I'm trying to do, is: 1. tell it to look in "workbook 1 name" in "sheet 1 name". 2. copy row 1 and...

I need to figure out how to write a macro that does the following: 1. Select the third sheet in the first workbook. 2. In the first workbook, set range j2 as the value to look for. 3. copy all of the data from the third sheet in the first workbook. 4. In the second workbook, search every...