consolidate lot details

  • Re: consolidate lot details


    Too complicated for a formula... would need to be VBA solution... do you have any code written yourself?

    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont. :P


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)

    _______________________________________________

  • Re: consolidate lot details


    Hi gentle_20052006


    Attached is a partial solution. As you'll see I have an issue that I've not yet resolved.


    Developing a relationship among the three sheets (Consolidated Invoice, Lot Wise Invoice and Output) is key to a solution...Princess Bride "He's only mostly dead"...well, I've mostly done that...not quite.


    Try it...CTRL + z will fire the Code.



    [ATTACH=CONFIG]68683[/ATTACH]


  • Re: consolidate lot details


    Thank you Jaslake. Great job done. 99% perfect. I thank this forum to stretching helping hands to needy people otherwise they would spend most of their time in writing vlookup and Pivot table. Great timely help jaslake. Good effort ger plante thank you. Keep the good work going jaslake.............

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!