Please see attache files.
1. Copy sheet and call new sheet “Results Summary”
2. Delete rows 1:9, and 11
3. Delete columns A, C-G and I-K
4. Name column C as “Coverage”.
5. Insert a column between before column A and name it “Sample No”. This column becomes column A after.
6. In this column copy only the last number(s) after A. For instance, 2-1667705-GBS3410A2 becomes only 2.
7. Insert a table and sort ascending based on the newly created numbers in step 5.
8. In D2, insert formula to divide value of C2 by the user input (provided by a msg box).
9. Apply this formula to all rows containing values in column A.
10. Select D2:to cell in D containing values and.
a. Set decimal 0 to 1.
b. Center numbers
c. High light cells using a less than formula using a number provided by user using a msg box.
d. Select columns A and D to create a scatter plot graph
Hello! I can create the macro using VBA. It will resolve all 10 points. It will be completed in 1-2 days. I have a big 30% rehire rate, you will not be dissapointed, thank you!
34 freelancers estão ofertando em média $343 para esse trabalho
Dear Employer, I perfectly understand all the steps that you have mentioned and will make a VBA tool to apply the steps on the file attached. Please message me to discuss further. Thanks and Regards, Ash
Hello, I would like to work on your project. I have a great experience using excel macros / VBA, formulas and charts. I can start right now. Regards.
Hi, I checked carefully your project description I can help you. I have a lot of experience in Excel Macro and VBA. I can provide satisfactory results with Excel MACRO. Please send me a message thanks
I read the job details carefully and I am damn sure I can deliver you A+ work. I can provide you results that you are looking for. Please consider me and message me for further details.