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

Tietoa työnantajasta:
( 10 arvostelua ) Singapore, Singapore

Projektin tunnus: #501442

52 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% 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 [login to view URL] would you send me the data which format is it in excel?) [login to view URL] 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