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.
52 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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.
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.
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ää
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.