VBA - Push column I data down depending on F
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: VBA - Push column I data down depending on F
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular
    Join Date
    Aug 2014
    Posts
    54
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA - Push column I data down depending on F

    Hi Dante,

    There inst a way. Experience on my end to know that "4a, 4b" are required for 4. The pattern that does exist is the date. So how it changes from 4/07 to 27/06 and then back to 4/07 on another valid code (original post)
    As for descriptions mentioning it, or codes being similar... That's not the case.
    Sorry, when i changed the names/descriptions i didn't think so much focus would be on those 2 columns.

    I can say that the WIP Qty 125 (product 4a) really belongs to product 5. The 25 below that belongs to product 6.

  2. #12
    Board Regular
    Join Date
    Aug 2014
    Posts
    54
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA - Push column I data down depending on F

    Thanks to you Both (Dante provided the guts and Foo with the change to date)
    It does work once filtering per Job. Once i ran it I've realised Due Date also changes for priority stock. It can have a separate date than the bulk which results in pushing everything down.

    I'll try to incorporate another variable into what you have provided to cater for that.

    Thanks heaps guys, been amazingly helpful.

  3. #13
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    5,673
    Post Thanks / Like
    Mentioned
    64 Post(s)
    Tagged
    14 Thread(s)

    Default Re: VBA - Push column I data down depending on F

    Quote Originally Posted by marshy3300 View Post
    Thanks to you Both (Dante provided the guts and Foo with the change to date)
    It does work once filtering per Job. Once i ran it I've realised Due Date also changes for priority stock. It can have a separate date than the bulk which results in pushing everything down.

    I'll try to incorporate another variable into what you have provided to cater for that.

    Thanks heaps guys, been amazingly helpful.

    Thanks footoo for the complement, good work.

    I like to help you. Thanks for the feedback.
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

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
  •