hello,
I need help with one issue (I uploaded excel worksheet with data) and I need this :
if in column A in some row is text "today" then delete this row and delete all rows until in row B wont be empty cell
I have start (If in A is "Today" then ... ) but thas's all
anyone who could help? THANKS !
Please Login or Register to view this content.
Last edited by miso.dca; 12-16-2009 at 05:24 AM.
As long as your pattern is consistent ("Today" with two rows inbetween), this should work. If you actual workbook is different or the patter varies then this will not work fully.
Please Login or Register to view this content.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Hi, Try this:-
Regards MickPlease Login or Register to view this content.
Palmetto - tahnks, yes, your solution works but unfortunatelly pattern is different, it isnt always just 2 rows ... (for two rows it isnt very difficult, I'd make it by myself)
MickG - sorry, but your solution deleted only row where was text "today" I need to delete whole yelllow area, but thanks !
OK. This works during testing for any pattern. It fills the "inbetween rows" with the word "Today" then just loops through to delete all cells with the word.
See attached.
Please Login or Register to view this content.
looks like your solution works perfectly Palmetto
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks