Need help with formula deleting rows

[siumui00]

Hello all,

I'm recording a macro and I have this task that I don't know how to tackle. The number of rows of data are different each week.

Main tab data:

Column A to L
Column F (Date Received) has date data and there are cells that are (blanks).

I want to look for all rows of data with Date Received prior to 2/1/2011 or (blanks), and delete them.


Please help. Your help is greatly appreciated.

[apo]

Hi..

Attach a sample workbook... the requirements are not that difficult (coding wise) .. but re creating others spreadsheets gets tiresome..

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[siumui00]

Hello all,

Thank you all for your help. I poke around and the codes below work. Although I'm still working on the syntax for checking for blank or IsEmpty() to delete rows that are blank and I can't get it to work yet. The codes work successfully deleting all rows that have Date Received prior to 2/1/2011.

Please Login or Register  to view this content.

[apo]

Hi..

Maybe this..

Please Login or Register  to view this content.

[siumui00]

Hello alansidman,

I apologize. I have modified my post to use code tags already. Thank you.

I see that apo's message has been deleted. Can you restore apo's message?

[siumui00]

Hi..

Maybe this..

Please Login or Register  to view this content.

Hello apo,

I did try that but it didn't work.

[JOHN H. DAVIS]

Try it with two ifs:

Please Login or Register  to view this content.

[siumui00]

Thank you JOHN H. DAVIS,

I tried and it didn't work.

I tried the 2 codes below and neither work.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Can you attach a sample, so we can see why the code doesn't work? To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

[siumui00]

Can you attach a sample, so we can see why the code doesn't work? To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Hello John,

I'm trying to attach the file but I don't see the paperclip icon. I saw it a moment ago and when I clicked on it to attach file, i had to log in again then it said I don't have permission.....

[siumui00]

Can you attach a sample, so we can see why the code doesn't work? To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Please see attachment.

I finally got it to work.

[JOHN H. DAVIS]

This works on the sample you provided. BTW your cells which appeared to be empty had spaces in them.

Please Login or Register  to view this content.

[AB33]

Filter code as an option, but dates behave funny in excel and still do not understand how they work.

[siumui00]

This works on the sample you provided. BTW your cells which appeared to be empty had spaces in them.

Please Login or Register  to view this content.

Thank you so much John. It works!!!! Although I have no idea why column H has spaces. I got the data from a daily e-mail. Thank you!!!

[siumui00]

Filter code as an option, but dates behave funny in excel and still do not understand how they work.

Hello AB33,

Thank you for helping me. I looked at the codes and still trying to understand part of the codes for I'm new to vba codes.


---------

Thank you all. Have a great evening!

[AB33]

Infact, you do not a code for this task. You could have recorded a filter function in excel and you are home and dry. A filter code is not much difference to the one you get from Excel's filter function.