Delete cells after searching for a value
Posted by No Clue on September 20, 2001 1:36 AM
I've got a problem! I've got in worksheets "Sheet1" all data from column 1 til column 26! In "Sheet2" cell "G10" and "G12" I wanna be able to fill in a date and that it will search in column 3 on Sheet1 in which all the dates are! If it finds a match with the dates or dates in between the dates filled in G10 and G12 that it will delete those dates in Sheet1 and that if for example it finds a date that matches it will delete all the data in that row from column 1 til column 26! For example if I have in Sheet2 G10 as date "9-01-01" and in G12 "9-20-01" that it will delete all the rows from column 1 til column 26 which contains a date that's between the dates in Sheet2 cells G10 and G12! And when that is done that it gives a message which says "Delete is completed"! Hope someone can help me? Thanks!
Posted by Eric on September 20, 2001 4:02 AM
Did you check my reply to your earlier post? (NT)
Posted by No Clue on September 20, 2001 4:05 AM
YEAH BUT I WANT IT WORKING THROUGH A MACRO NOT BY CLICKING MYSELF!!!
Posted by Eric on September 20, 2001 4:41 AM
No need to shout :-) You should get the "vb people" on this one
You could record all the steps as a macro, but that wouldn't give you the customized text message at the end, and would probably be very wasteful code-wise.
I'd recommend getting the attention of one of the virtual basic script people, I suspect the coding would not be too difficult for them.
Some, but certainly not all, of their names are:
Barrie Davidson
Russell Hauf
Rob Jackson
Ivan F. Moala
Damon Ostrander
Tom Urtis
Posted by No Clue on September 20, 2001 5:17 AM
I'm not shouting! Sorry! I think I've got it going already! But if someone knows how to do this tell me so I can compare it?
