Peruttu

Spreadsheet for basic IN/OUT Warehousing

This will be a simple job as compare to those complicated warehousing and inventory system.

Here's my objective:

1. Enter incoming cargo

- model no., location, customer, date, quantity

2. Store cargo information into master sheet

- search by model no., search receive date, search location

3. Generate location list

- Show models in location

4. Generate picking list

- Base on out going delivery order to generate picking list

5. Enter outgoing cargo

- Once cargo is release, minus from master sheet

- Show that cargo is out.

6. Generate Movement Chart

- show daily movement of cargo

- show movement of particular cargo by model no.

This excel spreadsheet system must be able to generate reports like I mention above. Able to send to customers and lock the sheet to prevent unauthorized amendments.

If you have any more recommendation to improve, please let me know.

If you need any samples or Delivery Order, please PM me.

Thanks for bidding.

Taidot: Excel

Näytä lisää: spreadsheet warehousing, job warehousing, job spreadsheet, job objective, job recommendation, job inventory, inventory job, cargo delivery, spreadsheet 2, reports in excel, picking, OUT, customer spreadsheet, compare spreadsheet, cargo, daily inventory sheet, generate reports excel, picking sheet, excel order system, order picking, inventory daily, daily inventory, compare excel inventory, inventory daily excel, excel compare inventory

About the Employer:
( 10 reviews ) Singapore, Singapore

Projektin tunnus: #501442

52 freelanceria on tarjonnut keskimäärin 142 $ tähän työhön

koolsidz

VBA Excel Guru. A very Simple task. Would suggest using a database with Excel as Excel itself is very poor when it comes to handling these kind of data.

80 $ USD 2 päivässä
(110 arvostelua)
6.0
YourAssistant

Hi…Here is our bid to express our interest in your project. For further details please see PMB….Thanks (Shakeel) Looking forward to your swift reply.

50 $ USD 1 päivässä
(42 arvostelua)
5.5
agihcam

Please refer to PMB.

80 $ USD 3 päivässä
(39 arvostelua)
5.2
srinichal

i CAN DO THIS

80 $ USD 2 päivässä
(10 arvostelua)
5.1
ggopi

Lets start. Please send me more details.

100 $ USD 4 päivässä
(21 arvostelua)
4.8
ExactSystems

Please see solution on PMB. regards

195 $ USD 5 päivässä
(2 arvostelua)
4.3
johnsinit

Dear Terry! I am an experienced Excle user, VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

135 $ USD 3 päivässä
(11 arvostelua)
3.6
FlashBack

hi i am ready to start the work. thanks Abir

70 $ USD 2 päivässä
(6 arvostelua)
3.4
trivietsales

Hi, I am willing to help you. Thanks, trivietsales

100 $ USD 3 päivässä
(1 arvostelu)
2.4
excelmodeler

I have developed this several times for the firm I used to work with. I expertise in reporting modules and can even share my work before we start.

180 $ USD 5 päivässä
(1 arvostelu)
1.4
qtorixsystems

Hello I am 12+ years of experienced programmer. i am always engaged in doing development like as u requested. Mapping business requirements to technical tools. For you i dont think excel is the best solution. I will de Lisää

300 $ USD 10 päivässä
(1 arvostelu)
1.0
coolsourav007

I am interested. Please give me a chance.

200 $ USD 100 päivässä
(0 arvostelua)
0.0
lashe

i dont need to start telling you about my past records, or how good i am.. You just need to trust me with this one

150 $ USD 1 päivässä
(0 arvostelua)
0.0
SaraswathiYedla1

Hey, This is Sara couuple of questions here [url removed, login to view] would you send me the data which format is it in excel?) [url removed, login to view] you provide me couple of samples so that I know what your expectation is. 3.I can send you a rough Lisää

170 $ USD 15 päivässä
(0 arvostelua)
0.0
mailsourabh0216

i have expertise hand on excel done course in it i will be able to deliver it properly

75 $ USD 3 päivässä
(0 arvostelua)
0.0
nedz06

Hi Sir, Please send to me the detailed description of the Job so that i can start. Thank you

50 $ USD 3 päivässä
(0 arvostelua)
0.0
sunitasoren

I would like to bid on this project. It would be my 1st project, so I would like to know about the hole content of the project. You have written all the objective you required but please provide me the other inform Lisää

150 $ USD 20 päivässä
(0 arvostelua)
0.0
kantisangma

hello sir,Im ready to start your job. thanks

40 $ USD 1 päivässä
(0 arvostelua)
0.0
SoulRock

I'll create a workbook using different sheets for the master data and transaction data. All formulas are inter-related and some macros can be used by pressing Ctrl+char..A sheet for documentation and help will be prov Lisää

200 $ USD 4 päivässä
(0 arvostelua)
0.0
mohitesr

I work in Supply chain and warehouse related activity, in one of India's best Engineering company (L&T). I have required experience in Excel and also have undergone formal training in advanced excel.

50 $ USD 3 päivässä
(0 arvostelua)
0.0