To put macros in an excel document
- or -
Post a project like this2773
£100(approx. $126)
- Posted:
- Proposals: 5
- Remote
- #1269857
- Awarded
Description
Experience Level: Intermediate
General information for the business: We are an education establishment
Kind of development: Customization of existing program
Description of every module: Each subject area currently produces an action plan using Word. However, we would like to use Excel. I have an action plan Excel document. Basically, I would like the 'specific subject' user to be able to type in the cells of their action plan, but then I would like the cells duplicated so they would then go to a 'master' action plan which will be held by the line manager who would be able to view the action points from a number of subjects. I believe this can be done through the use of macros.
There are 6 line managers, so I am not sure if they all need their own master, or you could create 1 master excel doc that I could copy 6 times.
Also I was wondering if the master document could be set up so that each subject's actions appear in the master in a different colour?
Description of requirements/functionality: Could there be a message reminder or some process that ensures users save what they have inputted into excel as they will be regularly updating their action plans?
OS requirements: Windows
Extra notes: I can send examples of the subject level action plan and 'master'. It is very basic!
Kind of development: Customization of existing program
Description of every module: Each subject area currently produces an action plan using Word. However, we would like to use Excel. I have an action plan Excel document. Basically, I would like the 'specific subject' user to be able to type in the cells of their action plan, but then I would like the cells duplicated so they would then go to a 'master' action plan which will be held by the line manager who would be able to view the action points from a number of subjects. I believe this can be done through the use of macros.
There are 6 line managers, so I am not sure if they all need their own master, or you could create 1 master excel doc that I could copy 6 times.
Also I was wondering if the master document could be set up so that each subject's actions appear in the master in a different colour?
Description of requirements/functionality: Could there be a message reminder or some process that ensures users save what they have inputted into excel as they will be regularly updating their action plans?
OS requirements: Windows
Extra notes: I can send examples of the subject level action plan and 'master'. It is very basic!
Ruth J.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
15 Sep 2016
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Good afternoon Ruth,
Would you be kind enough to send your examples. I will then be able to see the scope of work involved.
Regards
Tony H -
Hi Ruth, could you please send me a copy of this in order to give you a more accurate quote? Thanks, Rachel
-
Hi Ruth,
If possible, please could you send me through the example file. This will give me a better idea of how much work is involved and I can then produce an accurate quote for you.
Thanks,
Mark
133326133241133056
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