Excel Rounding Spreadsheet

Budget £250 - £750 GBP
Bids 20
Average Bid £252

I would like to take this excel template and program the spreadsheet so that I would be able to do the following
1. Sort on Column A (MD) and write output to new workbook so that each MD (shown by initials) would have its own worksheet - all data fields would populate the new worksheets in the new workbook called 'Doctor'
2. Sort on Column B (Floor) so that each Floor (shown by initials) would have its own worksheet labeled by the initials of the floor, in a new workbook called 'Floor' Only columns A,B, C, D and E would be exported to the new workbook
3. Both these workbooks would be saved to the local hard drive
4. The two sorts would be shown as buttons on the top of the spreadsheet

Post a Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • justindonlon Profile Picture

    justindonlon

    Norwood,  United States

    I have worked extensively in the financial industry with MS Excel, Access, SQL Server, ASP, VBA. I am looking to work with short term Excel or Access based projects. I work accurately with numbers, specializing in problem solving solutions, and reconciling data, as well as manipulating data so that it can be migrated from one system to another.

    ASP, Visual Basic, Excel, and SQL

  • sebdick Profile Picture

    sebdick

    Farnborough,  United Kingdom

    I'm a mechanical engineer working in the defense sector. I have experience in concept design, 3D CAD modelling and stress analysis. I have developed numerous engineering tools in MS Excel for other engineers and draughtsmen, and taught introductory courses in VBA. I am particularly looking for freelance projects creating, developing and improving spreadsheets and macros.

    Visual Basic, Data Entry, Excel, and Technical Writing

  • marianstoik Profile Picture

    marianstoik

    Constanta,  Romania

    Organization management bachelor, 6 years work experience in field management, human resource management master.

    Data Processing, Data Entry, Training, and Research

  • pararols Profile Picture

    pararols

    SANT JORDI DESVALLS,  Spain

    Excel, Data Entry, VBA ... Electrical & Mechanical Engineering CAD drawing Energy Efficiency Bests offers!

    Visual Basic, Graphic Design, Translation, and Windows Desktop

  • bubu77 Profile Picture

    bubu77

    Bangalore,  India

    We are a group of freelancer and our aim is to provide quality service at an affordable price. Our group focuses on helping business owners as well as individuals get customised software applications that fully meet their requirements with a professional lookup. We support development of small software packages, 2D/3D modeling and animation design, web development and design, graphic design, logo design, flash animation etc.

    PHP, ASP, C Programming, and Java

  • benefitworks Profile Picture

    benefitworks

    pune,  India

    Experienced in data processing and automation in MS Excel, Power point. Also experienced in .Net, standalone applications using multi threadings.

    PHP, Javascript, XML, and Visual Basic

  • sokhom168 Profile Picture

    sokhom168

    No,  Cambodia

    More than 5 years of experience as an Excel Automation developer (VBA) and Excel trainer. I always try to deliver flexible solutions that suit business needs and require no maintenance. During my business career I developed many Excel applications that are continuously used in business environment. I actively monitor developments in spreadsheet area while continuously being educated. From that, I have received many award in my work place such as CEO Change and Innovation Award, COO Award for Automated Tasks using Excel, and many recognitions and achievement in delivering top excel solution to them that can make 1 days-long task to be 1 click tasks. My business experience was gained in: - Banking (System & Process Champion, Finance Analyst) - Manufacturing (Accountant) - Independent tutor and consultant. Currently pursuing ACCA membership for additional skills. Service Description Flexible Excel solutions that suit your needs - Excel business application development with VBA (Visual Basic for Applications) - Excel Add-Ins - Excel UDFs (User defined functions) - Integration with other applications such as word, text file, csv and database. - Excel Modelling - Advanced Excel formulas and functions - Excel advanced training, Excel expert training and Excel VBA training

    Visual Basic, Excel, and Visual Basic for Apps

  • buyaspreadsheet Profile Picture

    buyaspreadsheet

    London Colney, St Albans,  United Kingdom

    Please view my website at www.buyaspreadsheet.com for much more information in relation to me and the services which I can provide. With more than 7 years experience of designing and implementing advanced Microsoft Excel and VBA based solutions, I am perfectly positioned to help both the individual and the business. One size certainly does not fit all, so I work with you to understand your needs and ensure you receive a customised but cost effective solution designed to maximise value for money. Professional background: - Six years employed at PricewaterhouseCoopers (PwC) in a hig hly analytical, client-facing consultancy role, providing services to a wide range of organisations. - A further 15 months at UBS, a leading Swiss bank and one of the biggest financial institutions in the world with offices in more than 50 countries, again in a highly analytical role.

    PHP, Visual Basic, Graphic Design, and Logo Design

  • slavisatosic Profile Picture

    slavisatosic

    Banja Luka,  Bosnia and Herzegovina

    ## BIO I am graduated engeneer of electrical engineering - computer science (in my country it is little above B.Sc.E.E., 5 years of under graduate study). Working almost 10 years in local companies as a database and softwer designer, programmer and system administrator. Also made several information system projects (alone, as well as together with team of experts). Now finishing postgraduate studies in area of database and SQL optimisation. ## Area of Expertise MS Access, VBA, Visual Basic, Visual Basic.NET, SQL Server, C#, ASP.NET

    C Programming, XML, Visual Basic, and .NET

  • shikhamehta Profile Picture

    shikhamehta

    Pune,  India

    I am an experienced freelance professional with over 7 years of experience. My expertise include excel based reporting and VBA Macros. I have created some elegant dashboards for various clients and have been highly recommended by them for the quality I deliver.

    PHP, C Programming, Java, and XML