Concluído

I need a simple macro written

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

Habilidades: Excel, Visual Basic

Veja mais: hello freelancer i need simple logo design and i have a pretty good idea what type of design i want, hello freelancer i need simple logo design and i have a pretty good idea what type of design i, i need a essay written for me, i need a essay written, i need a macro programmer, i need a paper written for me, i need a summary written for me, i need an ebook written for me, i need an essay written tonight, i need simple dynamic app with 4 screen, i need a full written article on early marriage, i need an essay written for me for free, i need help to written a letter my uncle asking him to pay my school fees, i need a logo written qteelvin, i need a macro wirtten and need a freelancer, i need an article written, i need an article written for mw, i need an essay written, i need an essay written for me, i need a paper written

Acerca do Empregador:
( 0 comentários ) Research Triangle Park, United States

ID do Projeto: #23894906

Concedido a:

sergiuloghin

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!

$350 USD em 2 dias
(275 Comentários)
7.7

34 freelancers estão ofertando em média $343 para esse trabalho

Webxpert4u

Yilong, I can easily create Macro in your excel sheet. Checking attached file. Message me to discuss in details. Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and .net Mais

$300 USD in 4 dias
(232 Comentários)
8.0
schoudhary1553

Hello, I can help you with your project - simple macro written I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several pro Mais

$500 USD in 10 dias
(340 Comentários)
8.0
asin1987

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

$500 USD in 3 dias
(191 Comentários)
7.7
P0L

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.

$250 USD em 1 dia
(346 Comentários)
7.4
ksriniravi

Greetings! Thanks for detailed, very clear and specific instructions along with sample file. The requirement is pretty straightforward and I can implement the same using macros. Format and user input integrity checks Mais

$250 USD in 2 dias
(202 Comentários)
6.9
MimiFL

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 Mais

$250 USD em 1 dia
(538 Comentários)
7.1
nagyzoltan68

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.

$250 USD in 2 dias
(125 Comentários)
6.5
ravinderkumar248

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 Mais

$250 USD in 2 dias
(17 Comentários)
4.5
Ladiginvladislav

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 Mais

$250 USD em 1 dia
(5 Comentários)
3.5
nemanjadj20

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 Mais

$250 USD em 1 dia
(2 Comentários)
3.2
maurineted5

A Data Scientist with experience in SPSS, CALCULUS, Advanced Excel, R programming, R Shiny, R studio and anything related to data science and python Master in Engineering, Electrical and Electronic Engineer, who is dyn Mais

$250 USD in 4 dias
(2 Comentários)
2.4
hantoyma

Hello, I have more of 10 years of experience working as a developer using Microsoft technologies, including vba for macros. I have worked in different implementations for word and excel, including integration with con Mais

$600 USD in 7 dias
(1 Comentário)
1.3
Akib2020

Dear Sir, I’m Javed. My computer experience is 12 year's more. I’m expert on Data Entry, Microsoft Advance Excel, VBA, Macro, Formula, Chart, Subnet Calculation, Automated Attendance and Microsoft Excel related any ad Mais

$250 USD in 2 dias
(3 Comentários)
1.5
piaohaofu

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

$300 USD in 2 dias
(1 Comentário)
1.4
azizayoubi

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 Mais

$250 USD em 1 dia
(1 Comentário)
1.0
anuranaaz

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.

$250 USD in 7 dias
(0 Comentários)
0.0
saghir88222

Hi there – My name is Saghir. I’ve read your brief and can see that you’d like to build a Document. My team has 6 years’ experience of designing,formatting and editing excel sheet,visual Basic. I would approach your pr Mais

$250 USD in 2 dias
(0 Comentários)
0.0
khanjzthanjzt

Hi I have read and understand the work, its in my domain. Allow me to make this macro for your according to the description. Warm Regards Sample https://www.freelancer.com/projects/marketing/Freelancer-help-bids/revie Mais

$500 USD in 7 dias
(0 Comentários)
0.0
shwetakalaskar03

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.

$500 USD in 2 dias
(0 Comentários)
0.0
mavanikl

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 Mais

$250 USD em 1 dia
(0 Comentários)
0.0