deleting certain rows

Hi everyone. I currently have an excel sheet that contains rows with very similar data. I would like to delete the rows if they contain the same first name, last name, DOB and category AND if columns x, y or z does not contain data. otherwise I want to keep the row. My knowledge is very weak...

I have a worksheet where the dataset will never be the same from day to day. I'm using filtering and I show only rows that do not equal a #N/A value. I recorded a macro to delete the non-#N/A rows. In this particular example, there are 101 rows to delete. How can I - without arbitrarily...

Hi, So I am trying to build a macro to pull data from one sheet in a workbook sorted by the data in column M. I currently have the macro written such that it pulls all of the data over to each of the new sheets and then deleting the info that is not applicable. Unfortunately the deleting is...

Hello I am working on a project that involves me sorting clients into various different groups based on parameters regarding what types of accounts they hold. I sorted the list down to the people who have two accounts and now I want to sort the original client info sheet down to this same...

hello, i have this macro which copies data from one worksheet and then paste specific cells on a specific worksheet. problem is that when the macro is used again it doesnt replace the existing data on the others worksheets, therefore i end up with replicated data. i need my macro to delete all...

Is there a way to delete a row completely out of excel without manually doing it row by row one at a time. Lets say I wanted to delete some of the excel rows in a address list that had apartments and Units. and it looked like this <colgroup><col><col span="2"></colgroup><tbody> 1 W 11th Pl...