purpleozzie
Board Regular
- Joined
- Jun 8, 2015
- Messages
- 64
Hi Guys,
I am trying to do something that is beyond my excel knowledge so hoping you could help..
Our company sells wine and all reps have a price list with over 1500 wines on and cost prices, sorted by region.. When we put together a wine list we go through this list and put prices in, I want to create a new worksheet that can basically create the wine list.. I want it to have a WHITE WINE heading and underneath this have all the priced up white wines with cheapest first, then a red wine heading, then Rose, then sparkling..
First off I know I'll need a helper column with an R, W, B (for blush as R is already taken) & S.. then a formula that can pull all the priced up W's then sort and put this under the White Wine heading and so on..
the other issue is that the worksheet with all the wines in changes name every month and is named June 2015 at the moment and obviously changes name every month..
Hope this makes sense..
I am trying to do something that is beyond my excel knowledge so hoping you could help..
Our company sells wine and all reps have a price list with over 1500 wines on and cost prices, sorted by region.. When we put together a wine list we go through this list and put prices in, I want to create a new worksheet that can basically create the wine list.. I want it to have a WHITE WINE heading and underneath this have all the priced up white wines with cheapest first, then a red wine heading, then Rose, then sparkling..
First off I know I'll need a helper column with an R, W, B (for blush as R is already taken) & S.. then a formula that can pull all the priced up W's then sort and put this under the White Wine heading and so on..
the other issue is that the worksheet with all the wines in changes name every month and is named June 2015 at the moment and obviously changes name every month..
Hope this makes sense..