Закрыт

Write a VBA Code

The Clear All button will

1, Uncheck all the checked CheckBoxes

2. Clear all contents in rows E6:E16

3. After 1 & 2 is complete, reps will then start checking the boxes in column AW for the reasons they want to display from column AW. These will then get listed starting in E6. After the reps completes checking the boxes, the data from column AW will display is column 3.

4. Blanks that appear in column E need to be filled in with the data from a lower row.

For example, the verbiage in row 9 now needs to move to row 7

-- the data in row 10 needs to move to row 8

- the data in row 13 needs to move to row 7

5. The numbering in column C should be automatic. In the example, it show 1 to 11 but wtih

just 4 reasons, the numbering should end with 4

Квалификация: Обработка данных, Excel, Архитектура ПО, Visual Basic, Visual Basic для приложений

Показать больше vba code create xml, vba code string gzip, tsv msaccess vba code, useful vba codes for excel, writing excel macros with vba, vba excel pdf, vba excel 2016, excel vba programming for dummies, vba syntax, excel vba programming pdf, vba language, write html code images, excel vba code optmization, vba code generate report excel, vba code check html link valid, vba code create pdf file access 2007 report, resize jpg vba code, excel vba code optimis, processor access vba code, vba code extract email text field

О работодателе:
( 0 отзыв(-а, -ов) ) McHenry, United States

ID проекта: #18531668

44 фрилансеров(-а) в среднем готовы выполнить эту работу за $90

cgullapalli

HI, I have gone through the detailed explanation given in the project description. Thank you for that. I have reviewed and understood the requirements. I will transfer the data based on the checkboxes selected in Больше

$50 USD за 0 дней(-я)
(830 отзывов(-а))
7.9
Webxpert4u

George, I am ready to write code in excel. Can we discuss? Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and .net for Applications (vba) inside out; writing Microsof Больше

$166 USD за 2 дней(-я)
(233 отзывов(-а))
7.9
schoudhary1553

Hello, 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 projects like this. For evidence you can see my profile. Больше

$180 USD за 3 дней(-я)
(323 отзывов(-а))
7.8
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have two macros in your Excel spreadsheet, one to clear checkboxes and another one to Больше

$40 USD за 0 дней(-я)
(195 отзывов(-а))
7.1
dgled

Hi, as I understand you want to show only checked reasons in column E by order (with no empty rows). I am a financial expert and gurus in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas Больше

$155 USD за 3 дней(-я)
(72 отзывов(-а))
6.9
zebracaro

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

$100 USD за 3 дней(-я)
(119 отзывов(-а))
6.7
branislavm

Hi! I think I am clear with everything and there will be no issue doing it, but I have a question about E column point 9 (if I get it right) - in the description that is a field with data, but in the worksheet that Больше

$55 USD за 3 дней(-я)
(228 отзывов(-а))
6.6
FerriSoft1

Hi! I can do this for you, and I can start right now, but I'll need more information. There are a lot of Clear All buttons, and other than the Ready To Print I dont get to see other checkboxes Thanks! Felice

$155 USD за 3 дней(-я)
(25 отзывов(-а))
6.3
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl Больше

$50 USD за 0 дней(-я)
(92 отзывов(-а))
5.9
macroPOL

Hello, I am Excel and VBA expert. I have seen the file. I understand the requirements. I can do it . If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-s Больше

$70 USD за 2 дней(-я)
(89 отзывов(-а))
6.0
TechnoGuruu

Hi, As per requirements I will develop VBA macro for you which will perform all these listed tasks as per description of the project. I have expertise in Excel, formulas, Excel VBA and finished many such projects. Больше

$99 USD за 3 дней(-я)
(57 отзывов(-а))
5.4
sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you Больше

$194 USD за 3 дней(-я)
(63 отзывов(-а))
5.9
lightingdavid

Hello? How are you? I have good experiences in "Write a VBA Code" as you can see my profile for these (Data Processing, Excel, Software Architecture, Visual Basic, Visual Basic for Apps). I have been working for 7 y Больше

$50 USD за 3 дней(-я)
(37 отзывов(-а))
5.3
akritisood94

I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main S Больше

$45 USD за 3 дней(-я)
(32 отзывов(-а))
5.0
vsprybhanu

Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully and saw attached file. I can check and uncheck checkboxes, clear specific ranges, manipulat Больше

$45 USD за 3 дней(-я)
(73 отзывов(-а))
5.3
accchow

please download sample for your reference at [login to view URL] the sample will show how to update the checkboxes and cell values

$222 USD за 3 дней(-я)
(23 отзывов(-а))
5.2
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

$50 USD за 2 дней(-я)
(75 отзывов(-а))
5.4
jasalaz100

Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after com Больше

$155 USD за 3 дней(-я)
(31 отзывов(-а))
4.9
katiewells3

I would love the opportunity to work with you on this project! I would break this project down as follows 1. Add the VBA to clear the check-boxes. The could would loop through all the boxes on the sheet and un-check Больше

$90 USD за 3 дней(-я)
(25 отзывов(-а))
4.9
nelumindralal

Hi, I went thru the description these tasks are similar to my regular VBA coding Contact me and I will start it by today I look forward to hearing from you Thanks regards Thushara

$100 USD за 3 дней(-я)
(25 отзывов(-а))
4.3