Cancelled

Excel Sheet for a small business purchases management

I am after a simple excel sheet that tracks my purchases on weekly bases.

The sheet will look like this:

Supplier Name: Date:

Supplier details: Order #:

Supplier Products:

Qty Description Net weight Price Total

1. Supplier name would be a drop down list

2. When a supplier name is selected, their details would appear along with their product list.

3. I would than specify the quantity number for order and click purchase

4. After I click purchase I want all the data to be banked in a location, so that every time I click on purchase the data would be saved automatically in a specific location for future retrieval.

Also the date and order number would automatically appear every time I open a new sheet, so that excel would automatically remember how many orders I have done.

I hope that’s all possible within excel.

Skills: Excel, Microsoft, Microsoft Access, Order Processing

See more: excel sheet purchases, excel sheet purchase management, business purchases excel, excel business purchases, purchase management excel sheet, business purchases excel sheet, small business excel sheet, order management excel sheet, new excel, time sheet, simple excel, sheet, price excel, business location, business list, business description, supplier purchase order, excel specific, excel weight, price sheet, weight excel, excel time sheet, access order management excel, excel product supplier list, excel data management

About the Employer:
( 4 reviews ) dharruk, Australia

Project ID: #602701

65 freelancers are bidding on average $72 for this job

koolsidz

Please see PMB

$200 USD in 4 days
(93 Reviews)
5.7
braghunath

I have been developing applications in MS Access since the year 2003. Your requirement will be better accomplished with a simple application developed in MS Access.I can take up this project immediately. I will pro More

$135 USD in 7 days
(3 Reviews)
4.1
d2imatrix

Hi, We can do this work. Please check PMB. Regards, d2imatrix

$100 USD in 5 days
(1 Review)
3.2
vishalgoyal4

Hi Ready to start. Waiting for your decision.

$80 USD in 1 day
(1 Review)
2.9
subhadippal

Hi, I am vba developer.I have experience in excel(vba and Userform based application , even integration with access DB , SAS, ..).I can provide you the solution.Check PM for details.

$120 USD in 4 days
(2 Reviews)
1.5
sdahad

HI, we can complte this project in Maximun 5 day's, with 100% accuracy Regards, Savan

$30 USD in 5 days
(1 Review)
1.0
theMagicNumber

Dear Sir/Madam please check your PMB. Thank You.

$100 USD in 2 days
(1 Review)
1.0
bhogal67

Hi Iam very much interested in your project and can deliver it on and before time

$30 USD in 3 days
(1 Review)
1.0
hashmi19

i done this project in 5 days

$100 USD in 5 days
(0 Reviews)
0.0
ZeusPaez

Im ready to Finish your project. VBA Excel Programer Regards

$50 USD in 3 days
(0 Reviews)
0.0
profphp

Hi, I would like to take up this project and can deliver it in 10 days. Let me know if you are interested.I am ready to work for less than 30$ also

$30 USD in 10 days
(0 Reviews)
0.0
aymansy

I can do by Excel or AccessDB as you want

$100 USD in 2 days
(0 Reviews)
0.0
MarjoleinJ

Hi, I'ld like to do it. Please reply to my PM and I'll send you a preliminary version.

$50 USD in 2 days
(0 Reviews)
0.0
nipunkhanna

This is achievable in Excel.

$100 USD in 7 days
(0 Reviews)
0.0
XymaSoft

Hello. Please see the private message board for details regarding my bid. Thank you.

$30 USD in 3 days
(0 Reviews)
0.0
mdrngypsy

This can be easily done through Excel and I would be happy to do it for you. I have extensive knowledge of Excel and spreadsheet functions. Also, I have managed companies organizing their expenditures so this project i More

$100 USD in 1 day
(0 Reviews)
0.0
mstech1

Please check PMB - Regards MS Tech.

$45 USD in 1 day
(0 Reviews)
0.0
bashir08

i m ready to work with ur project. waiting to get response from u

$30 USD in 30 days
(0 Reviews)
0.0
augustinerich

I am ready to handle this Project.

$31 USD in 7 days
(0 Reviews)
0.0
jbruce1982

This is a fairly simple task to complete. With input from you to ensure that you are getting exactly what you want, we could be done with this task a couple of hours. Please choose me if you want someone who is a stron More

$50 USD in 1 day
(1 Review)
0.0