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
Looking to make some money?
- Set your budget and the time frame
- Outline your proposal
- Get paid for your work
Bids on this Project
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.
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.
Organization management bachelor, 6 years work experience in field management, human resource management master.
SANT JORDI DESVALLS, Spain
Excel, Data Entry, VBA ... Electrical & Mechanical Engineering CAD drawing Energy Efficiency Bests offers!
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.
Experienced in data processing and automation in MS Excel, Power point. Also experienced in .Net, standalone applications using multi threadings.
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
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.
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
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.