delete rows

Hi I am looking to format a data dump into a pivot table friendly format for which I need a macro. My skills are very basic so I would appreciate your help a lot! The problem is that we have always 4 different Products including Quantity and Revenues in column K to R and not in database format...

So I found and manipulated code that Autofilters a specific column by criteria (if name is John) and finally deletes all of the other rows that don't have that name. Seems pretty easy but my code takes an entire 50 seconds to run which is wayyyy to long. Is there a way to rewrite this code...

I would like a macro that will search for the following text phrases in column H and delete 3 rows above, the row the value is in and 14 rows after the value. "Pallet 1 of 0" "Pallet 2 of 0" "Pallet 3 of 0" "Pallet 2 of 1" "Pallet 3 of 1" "Pallet 3 of 2" I have tried several codes and I am not...

Hello, I've been slowly building out multiple user forms through the help of the community. I need a Delete Command Button in my Search User Form that loops through my worksheet and deletes multiple rows that equal the Project Name selected in the Search User Form. For example, user selects...

Hi Guys, I'm having a problem deleting Rows in the spreadsheet from a Command Button titled "Remove". In short, I want to select an item from a list box within a userform and then click the "Remove" button to delete that row. Unfortunately after executing the command, "Run-time error '1004'...

Hello everyone! Is it possible to delete rows from an array in excel IF it contains ANY string of text from a separate array? Here is a sample of my data: Excel WorkbookAB1FirstEmail2Ryanryantg@gmail.com3Alalberk@gmail.com4JimJimalco@gmail.comSheet6 (6) My goal is for VBA to read this...

I have a report that lists data in column A and then "X"s in columns B-F. I want to delete the rows which do not have an "X". What is the easiest way to do this? Macro? VBA? I'm a real beginner with VBA. For example: This is what I have now... A B C D E...

Hi guys! I'm trying to use the macro in the thread below to erase the blank rows in my document - amongst other things. The top half is recorded, so please excuse any lack of coding eloquence! Sub Macro1() ' ' Macro1 Macro ' ' Cells.Select Range("E28").Activate Selection.Copy...

Hi, I am having trouble deleting the rows between two key words I have on my worksheet. I can select them but can't work out how to delete all the rows in between and not just the row that the first word appears on. So far I have the following code to select the rows between the key words: Sub...

Hi guys, I can't find a code that suits my needs, so I come to ask for your help. The basic idea I want to achieve is to have unique data in my sheet, but it's a bit more complicated then a basic RemoveDuplicates. There are some if's and but's I will try to explain as clear as I can. Col. A...

I would like to delete a row, if the cells in columns D, F, K of that row are blank. All three cells must be blank. Columns A to W have data. Data (heading) starts in row 5. Number of rows varies How do I do that? Thank you.

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

So what I am trying to do is delete unwanted rows in one Sheet if they do not meet the validation values from 2nd sheet. I have a tag list with tags that are associated to a system. Some systems are not part of the project so I need to purge these from the excel list before I can run a status...

I have no VB background and have been working on a template spreadsheet for 2 weeks. I have stumbled through a lot of the VB scripting i needed so far by finding samples online that I could figure out how to modify to meet my needs. BUT.... I have been banging my head for almost 2 days...

I have a complex workbook template which has all of a sudden added over a milliion extra rows on each worksheet. I've tried everything I know of to delete them and nothing seems to work. For reasons I won't go into, it's not going to work for me to copy and paste the information into a new...

Hello Guru's, I have a massive 1000+ row table in excel (A1:F1500) and I want to delete all of the blank rows. I know the F5, special, blanks trick but the problem is that some cells are blank while other cells in the same row have data. If I did the above trick it would eliminate E427 and A51...

I have a very large excel table that appears as follows: <tbody> Bob OH 3 Bob OH 4 Bob OH 5 Mary OH 2 Mary OH 3 Mary FLA 2 Ted AL 2 Ted AL 3 Ted NY 2 Jim NY 2 </tbody> I want to delete rows leaving only the row with the max value in column 3 The final table should appear as...

Hello, I need a macro that will delete rows based on a value in a specific column. I know this is not an uncommon code, but so far nothing I've found has worked with the little variations I have: 1) I want the number threshold on which to delete the rows to be a cell reference (i.e. so the...

I have column B filled with data that was delineated from extended raw information to now contain no more than 5 characters. After delineation the data now has values I want to keep and random pieces of text and numbers that I want to delete. The values i would like to keep will always be...

Hello everyone, can you please help me. I want to create Macro in VBA that will delete specific rows in excel. this is what I want to do I am working on t-shirts excel file, I want to have two options there "MEN" and "Women", when I click men it should delete all woman rows. I have know specific...