delete a range of rows

Hi I have a table with 3 columns - col_id, col_id2&Col_point. I have sorted the data for col_id2 and then col_id. col_id2 has same values for multiple lines and within the same values, col_id has unique values with value 1 common across different col_id2 values. Problem statement. I want to...

Hi, I'm looking for some help with a VBA macro I have. I'm trying to delete any row that doesn't start with a 1 or 2 in column A. This data changes daily so the amount of rows varies. The code I have below only seems to do what I need on a sporadic basis and after breaking it down for...

Hi, I have a spreadsheet containing current month and last month data. My goal is to create a macro to delete the last month of data and then point to a new workbook to copy and paste the new current month data into the existing workbook. Is there a simple VBA code to create this? For example...

Hey Team, <tbody> Experience V1 V2 Mobile No: Experience V3 v4 v5 Mobile No: Experience V6 Mobile No: Experience V7 v8 v9 Mobile No: </tbody> I want to delete Values between "Experience" to "Mobile:", ie v1, v2 , v3, v4 ....... Problem is , some has...

Hello all, I have no prior knowledge of VBA code, so please bear withme if this question has been answered before in some way or another. The context of the problem is that I have a relativelylarge (>100) number of .csv files which all follow the same format and the samethree rows need to...

I wrote a macro (mostly by recording it) that copies data from a section on one sheet then calculates the end of my table on another sheet and pastes (paste special, being that the data I am pasting is a formula and I need to paste the values) the data to the end of my table, which on its own...

Hello, I am looking for solution to delete rows with event time which I am not intrested in. As for example I would like to delete/clear every rows between time 6:00 AM and 6:05 AM with macro. What is more I would be great if macro would ignore the date and focus only on time because it is...

There is a bit of code I am using to remove rows where if certain text in the column is not present, the row is deleted, thus leaving only the header and the rows that do contain the required text. The code is as follows and works quite well: Sub DeleteRows()Dim r As Long, lr As Long lr =...

Hello, I am struggling to figure out how to delete filtered table rows. In my file, I have reports directly connected to our report server and am trying to update my Macro to delete filtered rows. I have tried many different ways to do this and i keep coming up short. Below is an example of...

Hi Everyone, I am a newbie! I was hoping for some assistance with the following code. I am looking to have this code, find the criteria in a sheet and delete ALL rows with that criteria. This code only deletes the first record it comes across. I tried to play with a loop but I am not sure...

'Range("A23").End(xlDown).Offset(1).Resize(ActiveSheet.UsedRange.Rows.Count).EntireRow.Delete So far I have this code to delete data after the last row. However, how can I edit the code to delete only A through E columns instead of entire rows? Thank you

I would like to write a vba code that if find a row contains "No Data" then delete seven rows to up. <colgroup><col span="7"><col></colgroup><tbody> RSV 134 ATN AT OT Close Name NA DT CRA ADJC ADJ NA No Data Found for selected </tbody> So...

Sub GatherInfoHimchanLooping() Dim exclude As String Dim endrow As String: endrow = Sheets("Info").Range("E100").End(xlUp).Row Dim Finalrow As String: Finalrow = Sheets("Info").Range("I100").End(xlUp).Row For i = 24 To endrow exclude = Cells(i, 5).Value Sheets("Data").Select...

Hi If I filter a table and the filtered result is what needs to be deleted (nothing else), How do i go about writing code to select the filtered rows to be deleted only (not the headers) within the Table or the rest of the worksheet?

I'm putting together a nutrition spreadsheet and I want to be able to click on checkboxes in rows and have the info (proteins/carbs/fats) be added or removed from a running total for that day. Any food that will make me go over the limit on any of the 3 areas I want to have removed from the...

I work with data on a regular basis that is badly formatted. In the data set I have every alternate row is blank. Each week the amount of data will vary so there could be 500 rows or 10000 rows. Is there a macro i can run that that will start at the first row containing data (typically row 4)...

Hi, how can I achieve deleting the entire row based on a text starting with letter "X" actually, I already have the code below from my previous inquiry and I just forgot to include this particular requirement. is there any way to embed the missing function? sub duplicate() Dim Rng As Range...

Hi, Is it possible to have a macro that deletes data from a table? e.g - If cell I10 (Sheet2) matches data in a table on Sheet1 then delete the row that the data is stored in on Sheet1

Hello Everybody, I have an excel file where I would like to delete rows if a list names appear in either column L or M. Would anybody know what VBA is required for this please? Thank you for your help. Noob

I have a listobject which can expand in size; sometimes I add new data underneath it and sometimes I delete rows. What is the best way to delete unused data underneath the listobject? Is it something like "delete all rows from 65553 up to listobject"? How do I do that? Will I have to loop...