Hello,
I need help with a visual basic code in excel.
I am trying to validate rows in 2 sheets. If column 6 is a date from two days before the current date, the whole row needs to be copied to a third sheet.
the current code i'm using looks like this
If Cells(rwindex, 2) <> "" And Cells(rwindex, 6) = "" Then
Currently this copies all the rows where column 6 is blank into a third sheet.
I dont have a problem with the copying bit, but what i am trying to say is
And Cells(rwindex, 6) > today()-2 then copy...
Are there any suggestions as to how i can get this to work?
Thanks,
Configuration: Windows Vista Firefox 3.0.10
: while insert my flash drive it will ask format but ihave data very important Change background cell with vb in excel 2007 step by step Conditional format excel external Conditional format excel interval vba Custom date format excel Date format excel Excel arrange data in one condition Excel copy data range Excel get data from another sheet Excel import data new row Excel long date formats Excel sheet date format to php mysql format How to convert excel column data to an array How to display excel column data to an array Ip cell format excel Vb.net excel format cells Vba excel copy data record sheet to sheet Vba excel copy data sheet to sheet do while