Do some Excel Work
£20-250 GBP
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.
Nº del proyecto: #10228009
Sobre el proyecto
Adjudicado a:
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
33 freelancers están ofertando un promedio de £149 por este trabajo
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
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
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.
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
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.
I will finish the project in 3 days. i will understand the project and will finish as soon as possible.
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
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.
* 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
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
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