Hey guys I was wondering if someone could give me some tips on the folllowing problem:
I have on my spreadsheet 18 columns of data (Quantity,Price,Quantity,Price,Quantity,Price etc.)
Each pair of Quantity and Price is for a different product.
What I need is to have a set of check boxes on another sheet, one box for each product, and for the data from that product to be shown in the Quantity and Price columns on this sheet. Thus narrowing the sheet with every quantity and price down to just showing the ones I need.
Any help will be appreciated
Bookmarks