Hi,
Please help to prepare a macro that will perform following steps.
1. Filter out & delete data with 'ABC' (column header) containing 'AB' or 'BC'
2. Filter out & delete data with "Date" (column header) between today till 30 days prior (today - 30). Now we are left with the data which are more than 30 days older.
Thanks.
Last edited by VKR; 02-09-2013 at 07:48 AM.
Hi, VKR,
you can narrow down the data by either using the Autofilter or Advanced Filter for further working - is it really necessary to delete all the other data? Either approach could be used as well (just with different selection) as a loop or an array to perform that action.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
I have solved my first point but still working on second. I have a code but not able to fit criteria to full fill my expectations. Please give some suggestion on this.
rngData.AutoFilter Field:=k, Criteria1:="= *****", Operator:=xlOr, Criteria2:="******"
What should be criteria to filter date column today till 30 days prior (today - 30days)?
Appreciate your response.
Thanks,
VKR
hHi, VKR,
maybe something like
although I donīt know if the range or the variable k are fitting.
Please Login or Register to view this content.
Ciao,
Holger
It worked after a little modifiction. Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks