Copy and insert row while altering data

Закрито Опубліковано %project.relative_time Оплачується при отриманні
Закрито Оплачується при отриманні

Hi am currently working on file that is long attached is the file, the top part is the data and the below part is the end result

I'm trying to write a code that will do the following

1) If cells in column D is larger than 99

2) 99 remains in column D and Insert a row below

3) copy data from columns A-C:E-F into the new row created below, the column D in the new row should be the remainder of n-99

4) If cells in column D in the new row created is larger than 99, repeat step 2-3 again

As I am still new to VBA, I could not to write anything that works. I appreciate any help you can provide. Thanks.

Введення даних Excel

ID Проекту: #17906673

Про проект

28 заявок(-ки) Дистанційний проект Остання активність 5 роки(ів) тому

28 фрілансерів(-и) готові виконати цю роботу у середньому за $24

MimiFL

Hi, i am serious freelancer with 100% completion rate and i believe i can help you. I've completed many similar projects in the past without a single problem. If you are interested in working with me, please message me Більше

$16 SGD за 0 дні(-в)
(490 відгуків(и))
7.0
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best rega Більше

$30 SGD за 5 дні(-в)
(226 відгуків(и))
6.9
rohitagarberg

hi sir, i have understood your requirement where you want to insert more rows if entered number is 99 as more data will be there to be entered, thanks

$16 SGD за 1 день
(362 відгуків(и))
6.5
SidhuDN

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Sidhu

$31 SGD за 1 день
(24 відгуків(и))
5.2
dataexplorer

"Hi, I have just gone through your project description and reviewed everything. Yes, I’m able to work as per your instructions in your "" Copy and insert row while altering data "" and able to provide accurate and qu Більше

$31 SGD за 1 день
(24 відгуків(и))
4.7
Farhinzaffar1

i am Data Entry. Data processing expert who knows the value of time, very hard working and always delivers the work on time .my motive is to make my employer happy without adding additional charges. If you are looking Більше

$17 SGD за 1 день
(9 відгуків(и))
3.0
poppsanirudha

Dear Hiring Manager, I read your project description. I understand what I need to do and I am able to do the job. I understand your requirement for this job. I've more than 3 years experience in related field. Feel fr Більше

$36 SGD за 1 день
(4 відгуків(и))
2.2
SarmadNazeef

Hello! My name is Sarmad Nazeef Ahmed and I am a professional and experienced content writer and copywriter. I am always committed to the highest level of professionalism. I always write SEO-Optimized content and ca Більше

$27 SGD за 1 день
(2 відгуків(и))
0.7
Sonu605060

I can do it

$27 SGD за 3 дні(-в)
(0 відгуків(и))
0.0
logoworld24

Hi there, what's up! Glad to have your attention even just for a short while. I've read all the project information . my type speed very high. so i can delivery very soon

$15 SGD за 0 дні(-в)
(0 відгуків(и))
0.0
Mohdsuhel9203

From what I understand about the job, it's a position that requires a lot of fast activity during the day, and that's the kind of job I thrive in. I love to stay busy and wear a lot of hats. Is my assessment of the env Більше

$27 SGD за 2 дні(-в)
(0 відгуків(и))
0.0
harishjoshi83

1. Good Knowledge of Excel. 2. Typing Speed. 3. Concentration 4. Communication Skill 5. Having Good working culture

$40 SGD за 2 дні(-в)
(0 відгуків(и))
0.0
cindydaines1994

poseo estudios en técnicas de oficinas manejo muy bien el área de atención al cliente soy una persona pro activa y cobraría un minio de 20 usd

$27 SGD за 1 день
(0 відгуків(и))
0.0
Shyamalilani

Hi, A great day to you, Relevant skills and experience proper typing without errors. Please give me an opportunity.

$16 SGD за 1 день
(0 відгуків(и))
0.0
Kinzarazzaq

Hi. I am always here to done your any type of Data Entry, MS Office, Any type of conversion or IT job. Please send me more information so i done your project. Thank you.

$21 SGD за 1 день
(0 відгуків(и))
0.0
sonupascal2018

I have done lots of data Entery jobs. I have done Excel and MS words jobs I have done copy past jobs also

$27 SGD за 1 день
(0 відгуків(и))
0.0
Achela1992

I can build you a macro to do your task. If you decide to give this to me will reach out to you to get the task more clarified.

$26 SGD за 2 дні(-в)
(0 відгуків(и))
0.0
Oryssia

I have a huge experience working with Excel macros. I have completed your project as a brain exercise. Please accept my bid.

$16 SGD за 1 день
(0 відгуків(и))
0.0
Jeckford

I can do this very quickly, I’m very experienced in VBA. I haven’t got a rating yet, so I’ve offered the lowest amount it would let me, I would have done it for free

$12 SGD за 1 день
(0 відгуків(и))
0.0
singhaniasl

I have done projects in visual basic and ASP. Visual basic VBA are almost same. I am well verse with Ms Excel. Waiting for your positive response

$21 SGD за 2 дні(-в)
(0 відгуків(и))
0.0