Copy and insert row while altering data

Cerrado Publicado hace 5 años Pagado a la entrega
Cerrado Pagado a la entrega

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.

Entrada de datos Excel

Nº del proyecto: #17906673

Sobre el proyecto

28 propuestas Proyecto remoto Activo hace 5 años

28 freelancers están ofertando un promedio de $24 por este trabajo

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 Más

$16 SGD en 0 días
(490 comentarios)
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 Más

$30 SGD en 5 días
(226 comentarios)
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 en 1 día
(362 comentarios)
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 en 1 día
(24 comentarios)
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 Más

$31 SGD en 1 día
(24 comentarios)
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 Más

$17 SGD en 1 día
(9 comentarios)
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 Más

$36 SGD en 1 día
(4 comentarios)
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 Más

$27 SGD en 1 día
(2 comentarios)
0.7
Sonu605060

I can do it

$27 SGD en 3 días
(0 comentarios)
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 en 0 días
(0 comentarios)
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 Más

$27 SGD en 2 días
(0 comentarios)
0.0
harishjoshi83

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

$40 SGD en 2 días
(0 comentarios)
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 en 1 día
(0 comentarios)
0.0
Shyamalilani

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

$16 SGD en 1 día
(0 comentarios)
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 en 1 día
(0 comentarios)
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 en 1 día
(0 comentarios)
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 en 2 días
(0 comentarios)
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 en 1 día
(0 comentarios)
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 en 1 día
(0 comentarios)
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 en 2 días
(0 comentarios)
0.0