I need VBA development on an existing Excel document
- or -
Post a project like this2383
$$
- Posted:
- Proposals: 7
- Remote
- #1713164
- Awarded
Google sheets apps script GAS VBA Excel Macro VB.NET ADD-INS Web Scrap API developer
Kharkiv
Data warehouse Architect/Consultant/ ETL Developer (Informatica, ODI, Pentaho), Database Expert/Programmer
Hyderabad
64986582008410811951192798139872614494331817999
Description
Experience Level: Intermediate
General information for the business: Homecare for people who are unwell
Kind of development: Customization of existing program
Description of requirements/functionality: In the existing Excel document (see attached) there are two macros. The one I need developing creates additional tabs when the button 'Worksheet split' is pressed. This works well and, in the case of sorting by 'Staff' gives each member of staff a worksheet for the week. At present the macro checks if a sheet with the name it is trying to create already exists and, if it does, it deletes that existing sheet.
What I want is one macro which creates a separate tab for each member of staff (just the same as it is now) but a separate macro producing which sorts by 'Patient' and, rather than creating a new tab for each Patient enters the data on a weekly work summary tab (called 'Work Summary' on this Excel workbook. This is because each Patient has some standard information which must not be overwritten (so in the case of PH on the existing sheet this is Lines 4 - 9)
There could be anything from 1 to 30 appointments which need adding and, of course, they must not overwrite the Patient below on the work summary. There could be anything from 1 client upwards each week.
I do not need any work undertaking on the 'Workbook and Email' macro at present
OS requirements: Windows
Extra notes:
Kind of development: Customization of existing program
Description of requirements/functionality: In the existing Excel document (see attached) there are two macros. The one I need developing creates additional tabs when the button 'Worksheet split' is pressed. This works well and, in the case of sorting by 'Staff' gives each member of staff a worksheet for the week. At present the macro checks if a sheet with the name it is trying to create already exists and, if it does, it deletes that existing sheet.
What I want is one macro which creates a separate tab for each member of staff (just the same as it is now) but a separate macro producing which sorts by 'Patient' and, rather than creating a new tab for each Patient enters the data on a weekly work summary tab (called 'Work Summary' on this Excel workbook. This is because each Patient has some standard information which must not be overwritten (so in the case of PH on the existing sheet this is Lines 4 - 9)
There could be anything from 1 to 30 appointments which need adding and, of course, they must not overwrite the Patient below on the work summary. There could be anything from 1 client upwards each week.
I do not need any work undertaking on the 'Workbook and Email' macro at present
OS requirements: Windows
Extra notes:
Peter S.
100% (22)Projects Completed
12
Freelancers worked with
7
Projects awarded
57%
Last project
13 Sep 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Peter
Timeline?
502097
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies