Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Stinker of a dilemma!

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!)

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •