With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
We use an Excel document for a weekly log sheet for a customer and would like to automate a portion of this task. We need to perform the following points.
1) Perform a conditional formatting task for certain cells that contain only numbers. Example: Only apply this script if there is a Yes in A1. If B1 is not between the values of C1 and D1 then fill B1 with Red to make it stand out.
2) One click to create a new sheet with the current readings onto a new sheet so the log can be printed and filled out by hand. Example: Click a button and if A1 has a Yes in it take the value from C1 on Sheet 1 and move it to B1 on Sheet 2. Leave C1 on Sheet 2 blank so it can be printed and filled out by hand. Lock Sheet 1 so it can not be easily changed.
This can be done with a macro, as I believe that will be the easiest way to perform it. We have a sheet we are currently using, and it will be provided after the job is awarded.
Sign in or Register to see more