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!
Bu iş için 34 freelancer ortalamada $343 teklif veriyor
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 am an Excel VBA expert and I can write your macro. Please check my profile and contact me to discuss further details. Regards.
I reviewed the file and this is definitely possible. I have 100% completion rate and i can code this for you today. If you are interested in working with me, feel free to message me so i can ask you 2 follow up questio Daha Fazla
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 Good Day, I can do this immediate after you accept my bid I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and [login to view URL] give me this o Daha Fazla
Hi sir. ⭐ Macro and vba Expert is here!! ⭐ I now am understanding your attachments,So I can do it perfectly in short time as your price. I have excellent knowledge and experience of creating User Form, Command Butto Daha Fazla
Hello? my budget will be discounted. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. Thank you for your time. I have attached samples of work very si Daha Fazla
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
Hello, I am Aziz Ayoubi, MS Excel and Access expert with more than 7 years experience, and 3 years with Google Sheets, VBA, Google Script and C# programmer and IT troubleshooting master. I am also a structural enginee Daha Fazla
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.
I can assure to complete the provided work on time and very accurately as i have experience and good knowledge of data entry and excel macros.
Hi, I have extensive experience of building macros for building comprehensive tools in excel and an automation of many tasks. I have also dealt with large size of data handling including data compiling, cleansing, mig Daha Fazla