Đã Đóng

par sheet for ordering

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.

Kĩ năng: Excel

Xem nhiều hơn: normalization schema vendor, sheet graphics, start paypal ordering html, kitchen par sheet template, par stock in restaurant, bar par sheet, stock sheet, restaurant par list template, par level calculator, how is a par level determined, excel inventory template with formulas, java web start time sheet, online ordering pizza start, vendor list excel sheet, excel sheet vendor pricing, vendor price sheet, vendor document list example, sheet price list vendor, vendor price sheet excel, vendor data excel sheet

Về Bên Thuê:
( 0 nhận xét ) United States

ID dự án: #18392820

17 freelancer đang chào giá trung bình $32 cho công việc này

zebracaro

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

$50 USD trong 1 ngày
(105 Nhận xét)
6.6
mateenbhatti94

Dear sir I have read the requirements and completely understand the project.I have get the idea you want the send sheet to move with first sheet and we will usa the vba or excel builtin function to do this. I have Thêm

$25 USD trong 1 ngày
(61 Nhận xét)
6.0
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 Thêm

$50 USD trong 2 ngày
(17 Nhận xét)
3.9
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 trong 14 ngày
(2 Nhận xét)
1.9
kabir133

I can work for you daily 2 hours

$55 USD trong 1 ngày
(0 Nhận xét)
0.0
$25 USD trong 1 ngày
(0 Nhận xét)
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 trong 1 ngày
(1 Nhận xét)
0.0
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 Thêm

$25 USD trong 1 ngày
(0 Nhận xét)
0.0
minhajislam87682

Hi there! I am Md Minhajul Isam. I read your job description and understand what u need. I have 4-year experience in Instagram, Instagram Marketing, Social Media Marketing, Social Networking SEO. I provide all types Thêm

$20 USD trong 1 ngày
(0 Nhận xét)
0.0
ranaobaid1995

Iam working for 2 ywars on MS Office

$20 USD trong 10 ngày
(0 Nhận xét)
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 trong 2 ngày
(0 Nhận xét)
0.0
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 Thêm

$25 USD trong 3 ngày
(0 Nhận xét)
0.0
william4989

Hello Employer, Your project post was very confusing.. Luckily, however, your problem is straightforward! I have used Excel almost every day during my Aeronautical Engineering degree. I have used it to make massive a Thêm

$45 USD trong 2 ngày
(0 Nhận xét)
0.0
Sibinmarkose

please give me the order before Sunday if you want to give me from 24to30I am little busy and try to add an example of your Excel so everyone will get your need [login to view URL] sibin Markose I am a faculty of commerce Thêm

$30 USD trong 2 ngày
(0 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
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 trong 2 ngày
(0 Nhận xét)
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 Thêm

$30 USD trong 1 ngày
(0 Nhận xét)
0.0