Hey all, long time no see
I have a problem I could do with some help with if that's cool? I need some fabulous VBA or a macro or something that will go through three sheets in a workbook. The sheets are called Low, Medium and High and what I need it do is if a row in either of these 3 sheets has the word "Completed" in column I, then it needs to copy and paste that entire row out and paste it into a sheet called Completed, in the next available row.
So it does this for all 3 sheets every time the Completed worksheet is activated. Also it needs to delete any duplicate rows in the Completed worksheet
Hard enough for you?
Whoever gets this one, gets a special prayer said about them tonight!
Nuttin' but love for y'all
Audiojoe
This message was edited by Audiojoe on 2002-03-26 07:33
I have a problem I could do with some help with if that's cool? I need some fabulous VBA or a macro or something that will go through three sheets in a workbook. The sheets are called Low, Medium and High and what I need it do is if a row in either of these 3 sheets has the word "Completed" in column I, then it needs to copy and paste that entire row out and paste it into a sheet called Completed, in the next available row.
So it does this for all 3 sheets every time the Completed worksheet is activated. Also it needs to delete any duplicate rows in the Completed worksheet
Hard enough for you?
Whoever gets this one, gets a special prayer said about them tonight!
Nuttin' but love for y'all
Audiojoe
This message was edited by Audiojoe on 2002-03-26 07:33