Produce a spreadsheet - 4 sheets with one pulling data from the others
- or -
Post a project like this2846
$$
- Posted:
- Proposals: 3
- Remote
- #1192215
- Completed
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
Description of requirements/functionality:
We require a spreadsheet where our staff can add information to the main sheet, but the data is taken from other source sheets.
We require 6 dropdowns (some dependant) and 2 vlookups.
We require this done in Google Sheets. There is an issue with Google Sheets not excepting spaces or numbers in data for named ranges. However, we understand this can be converted behind the scenes, preferably with some script.
We need to add new information to the 3 source sheets easily, which will dynamically update the dropdowns and vlookups.
We have created an Excel Spreadsheet that details the layout and the data type required in each cell. (https://drive.google.com/file/d/0B3dVW2oMNMfRVmJ6Q3VOQ0dMYmM/view?usp=sharing)
Many Thanks
Andy
Andy Y.
100% (63)Projects Completed
116
Freelancers worked with
58
Projects awarded
22%
Last project
16 Feb 2021
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