Transferring data from multiple sheets in workbook to one shee
Sorry, the earlier paste got a bit warped
Here's how it is for Cat1 & Cat2
Cat1
Qty Part# ProdDesc
b ... 10 Dat11
2 ... 10 Dat12
5 ... 15 Dat13
Cat2
Qty Part# ProdDesc
1 ... 14 Dat21
b ... 15 Dat22
3 ... 17 Dat23
b = blank (no qty input)
|