par sheet for ordering

Closed Posted 5 years ago Paid on delivery
Closed 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.

Excel

Project ID: #18392820

About the project

14 proposals Remote project Active 5 years ago

14 freelancers are bidding on average $32 for this job

zebracaro

I can do it for you quickly and exactly. Please contact me for saving your time and your money .

$50 USD in 1 day
(119 Reviews)
7.1
dataexplorer

"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

$50 USD in 2 days
(18 Reviews)
4.3
SymmInfo

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

$30 USD in 14 days
(2 Reviews)
1.9
sauden23

Hello Sir/Mam, I write in response to your ad seeking a Data Entry specialist. My name is Sujan Sauden. I am a dedicated and hard working person who believes in honesty and good working relation. Though I am new in More

$25 USD in 1 day
(7 Reviews)
1.7
vladernest

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

$25 USD in 3 days
(0 Reviews)
0.0
kabir133

I can work for you daily 2 hours

$55 USD in 1 day
(0 Reviews)
0.0
singurusanthoshk

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..

$23 USD in 1 day
(1 Review)
1.2
ranaobaid1995

Iam working for 2 ywars on MS Office

$20 USD in 10 days
(0 Reviews)
0.0
rafiul693

I am intersted this project Relevant Skills and Experience I know excel maximum formula like if,count,vlookup,subtotal etc

$30 USD in 2 days
(0 Reviews)
0.0
User1k

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.

$25 USD in 1 day
(0 Reviews)
0.0
kpa57

I have extensive experience with execl and can create formuals to automate your list in the preferred order/format for the third party.

$30 USD in 2 days
(0 Reviews)
0.0
sanjaygour2k

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

$30 USD in 1 day
(0 Reviews)
0.0