Need a formula or macro for the following: - repost

  • Status Closed
  • Budget $750 - $1500 USD
  • Total Bids 30

Project Description

I have an auditing checklist in excel and I would like it if when a point is missed, a statement is generated automatically at the bottom in the notes section. For example:

1. Safety equipment is present and accounted for: No

So because "no" was the answer, in the notes section a statement is automatically populated:

Notes:

1. The following equipment should be present: boots, gloves, etc etc.

Hopefully that explanation makes sense?

Get free quotes for a project like this
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online