Forum Discussion

A_SIRAT's avatar
A_SIRAT
Iron Contributor
Oct 14, 2023
Solved

Help to consolidate Data into one sheet.

Hi, I have attached an example file and would really appreciate your help. I have explained what I want on the last sheet named consolidated data. thanks in advance.
excel
Formulas and Functions
A_SIRAT's avatar
A_SIRAT
Iron Contributor
Oct 18, 2023

Lorenzo 

 

Thank you very much. I have done a few tests and it works perfectly 🙂

Would you be so kind and help me with the last request. I have just thrown a spanner in the works by adding a column named Master Data where I have indicated which varieties are divisible by 200 and others by 100.

  • A_SIRAT's avatar
    A_SIRAT
    Iron Contributor
    Oct 18, 2023
    This is very much welcomed.

    Thank you again !
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Oct 18, 2023

    A_SIRAT 

     

    On reflection - although I have no idea if you need this - I updated the formula for Total [Quantity] on 'Consolidation' so it works with filtered data

     

    Hope this helps

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Oct 18, 2023
    You're welcome. Take care
  • A_SIRAT's avatar
    A_SIRAT
    Iron Contributor
    Oct 18, 2023
    It's end of the story... (lol)
    Highly appreciated !

Resources