Do some Excel Work

Completado Publicado hace 7 años Pagado a la entrega
Completado Pagado a la entrega

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.

Entrada de datos Procesamiento de datos Excel

Nº del proyecto: #10228009

Sobre el proyecto

33 propuestas Proyecto remoto Activo hace 7 años

Adjudicado a:

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 Más

£122 GBP en 5 días
(79 comentarios)
5.7

33 freelancers están ofertando un promedio de £149 por este trabajo

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 Más

£200 GBP en 3 días
(194 comentarios)
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 Más

£305 GBP en 8 días
(149 comentarios)
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 en 4 días
(81 comentarios)
6.3
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 Más

£166 GBP en 5 días
(7 comentarios)
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 Más

£80 GBP en 2 días
(7 comentarios)
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 en 3 días
(1 comentario)
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 Más

£111 GBP en 3 días
(0 comentarios)
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 en 3 días
(0 comentarios)
0.0
Djey66

A proposal has not yet been provided

£55 GBP en 2 días
(0 comentarios)
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 Más

£150 GBP en 3 días
(0 comentarios)
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 en 3 días
(0 comentarios)
0.0
ga13nesh25

A proposal has not yet been provided

£67 GBP en 2 días
(0 comentarios)
0.0
jehovahjack

* I am a Home maker with 9 years of work experience * My work experiences include data entry jobs and quality checks for major sector of companies like Standard Charted Bank and Nokia India Pvt Ltd and hence can deliv Más

£111 GBP en 3 días
(0 comentarios)
0.0
hedyyunginger

A proposal has not yet been provided

£166 GBP en 3 días
(0 comentarios)
0.0
asri1

I usually analize data similar with that with excel.

£111 GBP en 3 días
(0 comentarios)
0.0
sujzzz

Just send me the sheet...

£150 GBP en 2 días
(0 comentarios)
0.0
np44776

A proposal has not yet been provided

£138 GBP en 10 días
(0 comentarios)
0.0
ramana110

A proposal has not yet been provided

£333 GBP en 8 días
(0 comentarios)
0.0
Optimistic17

Hi, I can automate this for you using VBA macros that will automate the entire report. Using macros it will be automated and would be user friendly so that it's easy for you to use. In case of any query, please l Más

£188 GBP en 5 días
(0 comentarios)
0.0
honeyotero

I am a type of person who wants to make my work done in as fast as I can. When I have something to be done, I will continue my focus on it. I can serve you a favor as long as I can manage it. I am responsible enough w Más

£111 GBP en 15 días
(0 comentarios)
0.0