delete rows macro

Hi I am a new VBA learner. Need help for code, to cut data and paste as values, then delete specific range of row when the cells in column D is blank Eg. I have a quotation table in my sheet (=Quote!$A$10:$AL$265). I would like to first cut of (=Quote!$A$10:$K$260) and paste as value...

Hi all, I've been doing a lot of searching trying to find a macro that can help me delete specific rows from a worksheet using data given in a second worksheet. As an example: Sheet1 has 500 rows with data contained within Sheet2 has in the A column, numbers 3, 80, 212 and 415. I need the...

Gday All :-) I am hoping if anyone could kindly please assist. Trying to achieve: VBA to delete all rows in a specific column i.e "A", where the value begins with "," Example Data: <tbody> Column A Bloggs, Joe Doe, John , Sam , Matt </tbody> Hopefully that does make...

I've always used the VBA autofilter solution to find zero values then delete target row. Works great and is fast... Now I'm facing a new quandary with additional data elements Col A Col B Col C Jan Feb Mar Apr Client A Product 1 Actual Sales 0 0...

I have a spreadsheet with about 8,000 lines with patient data. It is sorted by Patient Name (column B), then by Visit Date (column G). I need to delete all rows where a single patient does not have any 2013 dates and keep all rows where a patient has at least one 2013 date. For example: Joe...

Hello there, Could some one please help me with a simple code that can delete entire row if certain criteria is met in a single cell Example I have a bank statement where under a first column (DATA TYPE), the cell could contain either "DATA" or "TOTAL" How can I delete the rows contain the word...