InfinityMrsn
New Member
- Joined
- Mar 21, 2023
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
I extract data from a system and those numbers need to be processed into an order sheet of our customer.
I was hoping someone can help me with a formula to simplify and speed this up. Now I fill the ordersheet piece by piece, but the number of different products grows enormously so this takes a lot of time.
Additional information:
- The article numbers are not on equal lines and some article numbers do not appear.
Please find attached 2 screenshots. I would like the numbers of the yellow cells (file 1) to be filled in the green cells (file 2).
I was hoping someone can help me with a formula to simplify and speed this up. Now I fill the ordersheet piece by piece, but the number of different products grows enormously so this takes a lot of time.
Additional information:
- The article numbers are not on equal lines and some article numbers do not appear.
Please find attached 2 screenshots. I would like the numbers of the yellow cells (file 1) to be filled in the green cells (file 2).