Stinker of a dilemma!

Audiojoe · Mar 26th, 2002, 08:32 AM

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 ]

traversd · Mar 26th, 2002, 09:04 AM

Audiojoe,

Sounds like your working on some sort of Task priority list.

I have been working on something similar for a few days but with a slightly different approach. Your welcome to try it out if you like (It's not complete though!)

Audiojoe · Mar 26th, 2002, 09:12 AM

Yeah thanks man, I'll private message you my email address

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 26th, 2002, 08:32 AM	#1
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	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 ]

Mar 26th, 2002, 09:04 AM	#2
traversd Board Regular Join Date: Mar 2002 Posts: 82	Audiojoe, Sounds like your working on some sort of Task priority list. I have been working on something similar for a few days but with a slightly different approach. Your welcome to try it out if you like (It's not complete though!)

Mar 26th, 2002, 09:12 AM	#3
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Yeah thanks man, I'll private message you my email address