Excel macros & formulas

  • Posted:
  • Proposals: 4
  • Remote
  • #667729
  • Awarded
Stephen H.
Ali H.Simon P.Excel S. have already sent a proposal.
  • 1

Description

Experience Level: Intermediate
Estimated Job 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

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.