Create a packing list

Question

Hello,

Need to create a packing list from an order sheet.

This is how my order sheet looks like

Α/Α	Product Code	Product Description	Units	Box
1	010.002.01.0	Product 1	5	Α
2	010.002.02.0	Product 2	5	B
3	010.002.03.0	Product 3	5	C
4	010.002.04.0	Product 4	3	Α
5	010.002.05.0	Product 5	5	Α
6	010.002.06.0	Product 6	5	Α
7	010.002.07.0	Product 7	5	Α
8	010.002.11.0	Product 8	5	C
9	010.002.10.0	Product 9	5	B
10	016.001.01.0	Product 10	10	Α
11	016.001.06.0	Product 11	10	C

and trying to get something like that automatically.

Box	Product Description	Units
A	Product 1	5
	Product 4	3
	Product 5	5
	Product 6	5
	Product 7	5
B	Product 2	5
	Product 9	5
C	Product 3	5
	Product 8	5
	Product 11	10

It probably needs macros and VBA.

Any ideas?

Answer 1

That is exactly what the formulas do - they adjust based on your data set, and the CF hides the repeated values in the first column.

Answer 2

Dear Bernie,

Thanks for your reply. This works fine but I needed to create a form that will return the packing list for different orders with different number of products. That's why I mentioned VBA. Any thoughts?

Answer 3

No VBA - just formulas:

https://1drv.ms/x/s!AsKdy7Nfg_Fbji-1G007-tatJA2M?e=uiLBkd