Dear Chandoo
I have a excel database as shown below
Bill_no. Material
O12345. Brush
O12345. paste
O77896. Pencil
O77896. Slate
O77896 Rubber
(Bill_no is column A, Material in column of sheet1)
In sheet2 when user inputs bill_no the out of Material should come in transpose.
eg. If...