Tamamlanmış

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

Beceriler: Excel, Visual Basic

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) Research Triangle Park, United States

Proje NO: #23894906

Seçilen:

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!

%selectedBids___i_period_sub_7% gün içinde 350%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(275 Değerlendirme)
7.7

Bu iş için 34 freelancer ortalamada $343 teklif veriyor

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 Daha Fazla

$300 USD in 4 gün içinde
(232 Değerlendirme)
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 Daha Fazla

$500 USD in 10 gün içinde
(340 Değerlendirme)
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 gün içinde
(191 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(346 Değerlendirme)
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 Daha Fazla

$250 USD in 2 gün içinde
(202 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(538 Değerlendirme)
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 gün içinde
(125 Değerlendirme)
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 Daha Fazla

$250 USD in 2 gün içinde
(17 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
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 Daha Fazla

$250 USD in 4 gün içinde
(2 Değerlendirme)
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 Daha Fazla

$600 USD in 7 gün içinde
(1 Yorum)
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 Daha Fazla

$250 USD in 2 gün içinde
(3 Değerlendirme)
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 gün içinde
(1 Yorum)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
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 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$250 USD in 2 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$500 USD in 7 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0