Results 1 to 5 of 5

Thread: How to compare two worksheets in a dynamic way

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Neophyte Derubeis's Avatar
    Join Date
    Apr 2019
    Posts
    3
    Articles
    0
    Excel Version
    2019

    How to compare two worksheets in a dynamic way

    I would like to
    Compare two worksheets( Giacenzetoday and Giacenzetoday2- see attached files)
    to find

    1. How many product are in the worksheet Giacenzetoday2 and not in Giacenzetoday (new products)
    2. How many product are in both of them Giacenzetoday2 and in Giacenzetoday (products in stock)
    3. How many product are not in both of them Giacenzetoday2 and in Giacenzetoday (products processed)

    I think I understand, with POWER QUERY, how to calculate point 1, 2 and 3

    My first big problem now is to make this comparison dynamic (Giacenzetoday3 with Giacenzetoday2 – Giacenzetoday4 with Giacenzetoday3 an so on… ) with a lot of comparisons between two worksheets (day by day or moment to moment…because the flux of product flow is continuos )
    And mostly
    Add up dynamically the list of product

    • New (all the new from the first worksheet to the last worksheet)
    • In stock (all the product yet in stock from the first worksheet to the last worksheet)
    • Processed (all the product processed from the first worksheet to the last worksheet)



    Thank you all
    Attached Files Attached Files

Posting Permissions

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