delete rows automatically

Hi, I have a set of data which is exported into excel and I would like to automatically clean it up, so that it can be analysed. Once I select the entire data and sort it by column A, smallest to largest, it is then sorted by ticket number. I would then like to delete the rubbish on the...

I have a sheet with the columns below: <colgroup><col><col></colgroup><tbody> DC ITEM # DC 1 1 DC 2 2 DC 3 2 DC 3 3 DC 3 4 DC 4 1 </tbody> I would like to do the following: 1. copy the 'master sheet' based on the number of unique values in Column "DC". In this case, this would...

I'm using an autofilter delete macro to clear out unwanted rows without using loops. It works fine for one off number entries e.g "200". What I need to do is set the criteria to match any number beginning with 4, e.g. 400-499 but the wildcard "4*" does not work. There must be a simple solution...

I'm super new to this obvi, seeing as how i cant get this to work myself :/ All i need is a few lines of code that will delete the first two rows on a worksheet. thanks for the help :)

Hope somebody can help with this one: I am running a macro to combine several files into a single worksheet. After the single sheet has been created, only the top row's header entries should remain. I thus want to delete all rows that are exactly like row 1. The header entries are not always...

Hello, I'm fairly new to VBA and currently automating a weekly report. I extract this report from a sheet within a workbook managed by another department, then clean it up to be used as a source file for a larger report. Normally, I run this report on Fridays, but occasionally I'll do it...