Excel Macro to automate data entry to printable form
5363
£250(approx. $314)
- Posted:
- Proposals: 12
- Remote
- #10491
- Archived
Database Administrator, Typist, Powerpoint Presentation Formating, Network Designs and Secretarial Work
Brighton
303403196272403704943871451114532845344456595421556140567
Description
Experience Level: Expert
We have to complete various fields in an excel form, and then print, sign and send it. (old skool!)
The data is sourced from our excel database (dummy version attached). We are currently manually copying and pasting into the relevant fields in the data form ('subpub notifications' attached). Clearly this can be automated - we need your help
I have attached a couple of copies of the form we have to complete, with the fields highlighted which need to be entered.
The data necessary for each form is contained in one horizontal line in our excel database, so the lookup is quite straighforward. It is populating the fields that we need the help with, and automating for bulk output (10s to 100s at a time)
We want the macro to generate forms from selected records in the database at any one time - and to be able to do it to order as when required in the future.
By the way, it is not obligatory to generate an excel file, as long as we end up with a printable form in the same layout as the attached document.
cheers!
Jt
The data is sourced from our excel database (dummy version attached). We are currently manually copying and pasting into the relevant fields in the data form ('subpub notifications' attached). Clearly this can be automated - we need your help
I have attached a couple of copies of the form we have to complete, with the fields highlighted which need to be entered.
The data necessary for each form is contained in one horizontal line in our excel database, so the lookup is quite straighforward. It is populating the fields that we need the help with, and automating for bulk output (10s to 100s at a time)
We want the macro to generate forms from selected records in the database at any one time - and to be able to do it to order as when required in the future.
By the way, it is not obligatory to generate an excel file, as long as we end up with a printable form in the same layout as the attached document.
cheers!
Jt
John T.
0% (0)Projects Completed
2
Freelancers worked with
2
Projects awarded
67%
Last project
18 Nov 2010
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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