Stinker of a dilemma!

Audiojoe

Active Member
Joined
Feb 20, 2002
Messages
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
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
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!)
 
Upvote 0

Forum statistics

Threads
1,213,560
Messages
6,114,304
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top