Đã hoàn thành

Do some Excel Work

I would like to stream line my buying system within my company.

Currently we buy between 150-300 stock items per week from between 15-20 different suppliers, we choose which supplier we will buy from generally based on price but also credit terms.

I have already part created a spread sheet that on the left hand side has my entire 'shopping list for this week and along the top has all of the supplier names. Currently each supplier has 3 cells allocated to it. The one on the left is a button where if I press x, it highlights all three cells in yellow and auto fills the selected supplier and price onto my 'shopping list'. The middle one is where that particular supplier price is loaded and the one on the right is for any notes.

1)I would like this spreadsheet to high light to me the suppliers with the cheapest price changing the colour of the writing to electric blue and bold (bear in mind we may have 3 or 4 suppliers who quote the same cheapest price). And possibly suggest which supplier I should buy from based on lowest price, longest credit terms, and minumum order (if possible) and auto fill 'the best supplier' and price onto my shopping list (by highlighting in orange maybe). This must be an over ridable function as I may choose, based on location or any other factor.

2) I would then like the spreadsheet to create tabs along the bottom which auto fill in each particular suppliers individual order. If possible I would like a button which links each sheet to my outlook so that I can e-mail each individual suppliers automatically.

3) At the top of the main page, I would like the sheet to have a date button. This date should then auto fill into each individual supplier order (in their individualised tabs along the bottom)

4) There is a tab at the bottom which basically copies the 'Shopping list' word for word, which gives me a version I can manipulate using filters for my own benefit.

5) I would like to create a summary sheet which tells me how much has been bought from which supplier and can then manipulate this data (based on my credit facility) to tell me how much I will need to pay in 1 week/ 2 week/ 3 week/ 4 weeks/ 5 weeks etc.

And also which deliveries are coming n on which dates and which orders need to be collected.

Kĩ năng: Nhập liệu, Xử lí dữ liệu, Excel

Xem nhiều hơn: writing on line shopping, on line supplier, on line stock supplier, left hand writing, excel work in company, cheapest suppliers

Về Bên Thuê:
( 1 Nhận xét ) Essex, United Kingdom

ID dự án: #10228009

Được trao cho:

royalcalif

Hi Mr. Employer I can do this project in effective manner with 100% accuracy report to fulfill your requirements and I assured that I will provide you 24 / 7 communication support during the project. Pm me for more i Thêm

£122 GBP trong 5 ngày
(79 Đánh Giá)
5.7

33 freelancer chào giá trung bình£149 cho công việc này

cugamelover

I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I've done a lot of similar work. I could send you samples of my work if you wish. Please Thêm

£200 GBP trong 3 ngày
(194 Nhận xét)
7.1
shikhamehta

Hello there, I reviewed your spreadsheet and also your requirements description in detail. I think there are several improvements that could be done in your spreadsheet and also the process you mentioned in the requ Thêm

£305 GBP trong 8 ngày
(149 Nhận xét)
6.5
jkrish

I have sound knowledge of excel and had worked before on similar projects. Please check my reviews for my past experience and other details. Hope to hear from you. Regards, Krish.

£222 GBP trong 4 ngày
(81 Nhận xét)
6.3
£127 GBP trong 3 ngày
(67 Nhận xét)
5.4
mjanecek

Thank you posting this interesting project. Thank you also for your clear and detailed specification. See my notes bellow: 1. A simple VBA macrro would handle this. Filling in the provider on the left would be triger Thêm

£166 GBP trong 5 ngày
(7 Nhận xét)
3.8
appangad1987

I am an accountant from the Philippines. I have more than seven years of experience in the field of Accounting, Finance, and Tax. I had also worked before in oDesk for three years but had to stop because I accepted a f Thêm

£80 GBP trong 2 ngày
(7 Nhận xét)
2.8
javvva

Dear Sir/Madam, I would be glad to help you with this project. I have excellent MS Excel skills (including the ability to write VBA macros). I will do my best to meet your expectations. Best regards, Jana V.

£200 GBP trong 3 ngày
(1 Nhận xét)
1.0
gkarunesh

I am an IT professional with 10 yrs industry experience. I have also done my MBA, where all the competencies related to consultancy and how to run a business smoothly are learnt. I can help you in 2 ways: 1. Provide Thêm

£111 GBP trong 3 ngày
(0 Nhận xét)
0.0
£150 GBP trong 3 ngày
(0 Nhận xét)
0.0
jain111chankit

I will finish the project in 3 days. i will understand the project and will finish as soon as possible.

£111 GBP trong 3 ngày
(0 Nhận xét)
0.0
£105 GBP trong 3 ngày
(0 Nhận xét)
0.0
Djey66

A proposal has not yet been provided

£55 GBP trong 2 ngày
(0 Nhận xét)
0.0
£150 GBP trong 3 ngày
(0 Nhận xét)
0.0
£150 GBP trong 3 ngày
(0 Nhận xét)
0.0
£200 GBP trong 3 ngày
(0 Nhận xét)
0.0
£211 GBP trong 3 ngày
(0 Nhận xét)
0.0
£150 GBP trong 3 ngày
(0 Nhận xét)
0.0
nichoyoswayz

Haloo, My name is Nicholas: I have a good typing speed of averagely 40 words per minute and i understand all new versions of the microsft suite from2003, 2007, 2010, 2013 and 2016 respectively. Im willing to work this Thêm

£150 GBP trong 3 ngày
(0 Nhận xét)
0.0
webplanet9

Hello Dear, I m Electrical engineer working as a purchase manager and already done same projects taking quotations and shorting them, I can do that with good accuracy. Also I have good experience of Alibaba.

£111 GBP trong 3 ngày
(0 Nhận xét)
0.0
£144 GBP trong 3 ngày
(0 Nhận xét)
0.0