Customize Excell Spreadsheet/Pricing Sheet
- or -
Post a project like this$$$
- Posted:
- Proposals: 10
- Remote
- #1936809
- Expired
50666684952082701017629106801913718271449473211928321351352144627
Description
Experience Level: Expert
The job is to add additional pages to an existing pricing sheet. The sheet will be made up of 2 parts 1. the selection panel at the top where the criteria is determined. A flat file data section that holds the data. the data is selected and populated into another page on the Excel. The sheet is macro enabled so you will be customizing an existing sheet. I will provide the design and data. The job is for to create the right functionality and populate the selected data in the correct field.
Suppliers provide a flat file (raw data) and a Matrix file that automates the required price data based on a selection. the job is to combine these two files and create a new page for each suppliers data. the matrix part will remain, the flat file (raw data) will need to be able to be cleared and pasted with new data whenever required.
Take a look at the page example, I have combined the two files as an example, I can explain the rest when we discuss the job. I will detail the scope in more detail as soon as the design and requirments have been agreed.
Regards Ian
Regards Ian
Suppliers provide a flat file (raw data) and a Matrix file that automates the required price data based on a selection. the job is to combine these two files and create a new page for each suppliers data. the matrix part will remain, the flat file (raw data) will need to be able to be cleared and pasted with new data whenever required.
Take a look at the page example, I have combined the two files as an example, I can explain the rest when we discuss the job. I will detail the scope in more detail as soon as the design and requirments have been agreed.
Regards Ian
Regards Ian
Ian T.
100% (72)Projects Completed
89
Freelancers worked with
62
Projects awarded
14%
Last project
30 Jan 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Ian,
Is the job still open?
Thank you in advance,
614397
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