One one page I have three columns that contain
Lot Price Buyer
This sheet is used to enter the information about an item
Onto a seperate sheet (invoice) I want to extract each lot number that a buyer has bought. I have tried index, match but it will return only one line. Have also used the advance filter but have not figured out how to make it change automatically when I change the buyer number. Thanks for your help
Lot Price Buyer
This sheet is used to enter the information about an item
Onto a seperate sheet (invoice) I want to extract each lot number that a buyer has bought. I have tried index, match but it will return only one line. Have also used the advance filter but have not figured out how to make it change automatically when I change the buyer number. Thanks for your help
