Derubeis
New member
- Joined
- Apr 29, 2019
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2019
[FONT="]I would like to[/FONT]
[FONT="]Compare two worksheets( Giacenzetoday and Giacenzetoday2- see attached files)[/FONT]
[FONT="]to find[/FONT]
[FONT="] [/FONT]
[FONT="]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 )[/FONT]
[FONT="]And mostly[/FONT]
[FONT="]Add up dynamically the list of product[/FONT]
[/FONT]
[FONT="]Thank you all[/FONT]
[FONT="]Compare two worksheets( Giacenzetoday and Giacenzetoday2- see attached files)[/FONT]
[FONT="]to find[/FONT]
- How many product are in the worksheet Giacenzetoday2 and not in Giacenzetoday (new products)
- How many product are in both of them Giacenzetoday2 and in Giacenzetoday (products in stock)
- How many product are not in both of them Giacenzetoday2 and in Giacenzetoday (products processed)
[FONT="] [/FONT]
[FONT="]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 )[/FONT]
[FONT="]And mostly[/FONT]
[FONT="]Add up dynamically the list of product[/FONT]
- 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)
[/FONT]
[FONT="]Thank you all[/FONT]