Excel Spreadsheet Development/Macros/Templates/Linked forms
- or -
Post a project like this4225
£22/hr(approx. $28/hr)
- Posted:
- Proposals: 7
- Remote
- #174407
- Awarded
Excel, Access, VBA Developer Expert. Specializing in Excel and Access VBA automation.
Leeds
11744167818106656246400254993293410349294
Description
Experience Level: Expert
Development of a series of linked Excel Templates.
We need a master form set up to hold all master and variable data on a job-by-job basis. From this, a series of linked templates need to be set up, which would pick up information from the master template.. or which can accept user input information in some cells. These are to be formatted with headers/footers/logos etc and set print areas to fit to Landascape A4, to produce quotes, sales and purchase orders and invoices. Once each stage in a "job" is final, we want a macro written to turn the sheet to pdf and then have the option to print, save to server, or email.
Later, we would like to add look up fields to the master form to fill in cells via lookup from database (probably a Zoho creator database).
And if possible, when its all tried/tested and working, we would like to upload the worksheet to google docs so we can share information with our overseas teams.
We need a master form set up to hold all master and variable data on a job-by-job basis. From this, a series of linked templates need to be set up, which would pick up information from the master template.. or which can accept user input information in some cells. These are to be formatted with headers/footers/logos etc and set print areas to fit to Landascape A4, to produce quotes, sales and purchase orders and invoices. Once each stage in a "job" is final, we want a macro written to turn the sheet to pdf and then have the option to print, save to server, or email.
Later, we would like to add look up fields to the master form to fill in cells via lookup from database (probably a Zoho creator database).
And if possible, when its all tried/tested and working, we would like to upload the worksheet to google docs so we can share information with our overseas teams.
Jenny K.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
50%
Last project
16 Oct 2012
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