par sheet for ordering
$10-30 USD
Paid on delivery
I have an ordering list I use every week at the restaurant. I've written it so items that are grouped together in my inventory are also grouped together on my list that I fill out for orders.
my problem is that my list is in not the same order as my vendors ordering list. they have mixed products from paper to walk-in cooler items to the freezer items all mixed in together.
I was hoping that when I enter in on one spreadsheet all of the items I want to order let's say on tab 1, when I'm done I could click on tab 2 and they could be there as well.
the only difference is that on tab one as I enter them in in the order that I need to enter them in because of my inventory on tap to they would then be populated into that list but it wouldn't be in the same order as tab one.
it's kind of confusing. on my ordering sheet that I use for the company we ordered through they might have mayonnaise and then pickles and then paper products and then chicken wings... they have no rival reason for their list when you do your ordering. when I make my list out it's done in grouping so I could do all of my paper products and then move into the walk-in cooler and do all of my produce and then my meats and have them in groups.
so as I was saying in tap 1 I would like to have my list of products in my grouping for my restaurant but when I click on tab 2 all of the numbers that I've entered within translate into the proper order on the second one which would be in the order of my truck ordering.
an example would be when I am starting my list of ordering I walk into the cooler and I start with produce in the very first thing is tomatoes and the second thing is lettuce and so on. when I click on tab 2 the list from my vendor tomatoes might be 87th on their list and lettuce 237. I would like the amount of tomatoes I need to order that I have on line one translate over to line 87 on the second tab.
as well as lettuce online 2 on the first tab but when I click on the second tab lettuce that's much further down the list would translate its number to that list. that way when I open up my order form online I can just look at my list and all of my numbers will be in order of how the company online wants me to put the orders in. they obviously have no idea how my restaurant inventory of setup.
also I'd like to have a par setup on it as well so I can have a piece number of what I should have on hand and then how many I should order next to it.
I'm sure you'll have many questions. Please, I hope I explain this mildly coherently.
Project ID: #18392820
About the project
14 freelancers are bidding on average $32 for this job
I can do it for you quickly and exactly. Please contact me for saving your time and your money .
"Hi, I have just gone through your project description and reviewed everything. Yes, I’m able to work as per your instructions in your current project and able to provide accurate and quick service. You know! I’m eff More
It is possible and understand your problem. If you can send me a sample, I will send it back with hw solution. You can award project and pay if the solution solves your problem. Thank you
Podríamos ordenar la lista por medio de tablas dinamicas en un base de excel y ordenandolas en forma ascendentes o dedescendientes según convenga usando más de una hoja en el mismo archivo de excel Relevant Skills and More
I have experience of nearly 3 years in data entry in companies. I can type with less errors. I am very dedicated in assigned work. I will be thankful to you if you provide work to me to met my livelihood..
I am intersted this project Relevant Skills and Experience I know excel maximum formula like if,count,vlookup,subtotal etc
I have done this in the past. I used google sheets. Please message me. I would like to speak with you to get into visual details.
I have extensive experience with execl and can create formuals to automate your list in the preferred order/format for the third party.
Hi, I don't have a question right now, I have a clarification. Please explain "also I'd like to have a par setup on it as well so I can have a piece number of what I should have on hand and then how many I should o More