Excel macros & formulas
- or -
Post a project like this3357
$25/hr
- Posted:
- Proposals: 4
- Remote
- #667729
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
Description of excel work: We have an excel workbook that takes data from a data source "raw files" and then puts the data into more readable and actionable data tables. There are formulas and some macros involved. We want to review and rebuild to incorporate better formulas, macros, pivots, whatever and make it cleaner, easier to read and more efficient.
We want to have a mechanism, where the user selects Yes or No for a certain transaction (a "PO") and then all of the other lines on that PO change to Yes or No as well. For example, US774 has two lines US774-1 & US774-2. If the user selects Yes for US774-1, then US774-2 should also be Yes. If they select No, then the other one should change to No.
Design and target audience: Design should be simple but decent to look at
Extra notes: Willing to negotiate price or change to fixed bid. Lets talk to make sure we are on the same page
We want to have a mechanism, where the user selects Yes or No for a certain transaction (a "PO") and then all of the other lines on that PO change to Yes or No as well. For example, US774 has two lines US774-1 & US774-2. If the user selects Yes for US774-1, then US774-2 should also be Yes. If they select No, then the other one should change to No.
Design and target audience: Design should be simple but decent to look at
Extra notes: Willing to negotiate price or change to fixed bid. Lets talk to make sure we are on the same page
David W.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
2 Feb 2015
United States
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