Excel Spreadsheets - Set up automatic reports/ merge/ extract
4595
£250(approx. $311)
- Posted:
- Proposals: 20
- Remote
- #89385
- Archived
Expert Mobile and web - AngularJS, C#.NET, XAMARIN, PHONEGAP, React, VSTO, ASP.NET, WPF, MVC, VB.NET, HTML, jQuery, CSS, Winforms
City of London
39320213354211975203436201414195397187227177369123296117441113378107373
Description
Experience Level: Expert
I have a project management master spreadsheet that tracks risks, issues etc - there are ten tabs currently and will probably be more in the future.
I have a number of staff who supply information for the master spreadsheet (across all worksheets) - I currently copy and paste this information manually.
So my first requirement is that I would like to automate this process using excel. I would anticipate a form based spreadsheet that I supply to the team that they input into - and some coding in the master that extracts this information automatically and appends it to the master.
My second requirement is to produce a number of automatic (click of a button) reports (primarily splitting internal and external data) that filter the information in the master spreadsheet (across all tabs) and present in a printable format (I was thinking an additional worksheet - formatted to print in A4 - with preset page layout so that again I can just press a button).
Any questions please feel free to ask.
I have a number of staff who supply information for the master spreadsheet (across all worksheets) - I currently copy and paste this information manually.
So my first requirement is that I would like to automate this process using excel. I would anticipate a form based spreadsheet that I supply to the team that they input into - and some coding in the master that extracts this information automatically and appends it to the master.
My second requirement is to produce a number of automatic (click of a button) reports (primarily splitting internal and external data) that filter the information in the master spreadsheet (across all tabs) and present in a printable format (I was thinking an additional worksheet - formatted to print in A4 - with preset page layout so that again I can just press a button).
Any questions please feel free to ask.
Darren T.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
25 Apr 2024
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