Lukket

Copy and insert row while altering data

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.

Evner: Dataindførsel, Excel

Se mere: sql copy rows in same table, sql copy records into same table change one field, mysql copy row, insert into same table sql server, sql duplicate row except one column, sqlite copy row, sql copy row into same table, sql copy rows into same table change one value, retrieve data site parse copy database, data entry jobs copy paste philippines, data entry processing copy writing proofreadingrewriting website design, excel macro copy next row, excel vba copy filter row, simple copy paste easy job data entry work, basic data entry job copy paste text, copy paste row access, data entry cut copy past, data entry online copy paste job, data mining copy urls paste excel data entry work, find data internet explorer copy excel macro

Om arbejdsgiveren:
( 0 bedømmelser ) Singapore, Singapore

Projekt ID: #17906673

29 freelancere byder i gennemsnit $24 på dette job

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 Flere

$16 SGD in 0 dage
(400 bedømmelser)
6.8
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 Flere

$30 SGD in 5 dage
(208 bedømmelser)
6.8
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 på 1 dag
(294 bedømmelser)
6.3
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 på 1 dag
(16 bedømmelser)
4.7
Asfaqulislamtita

Hi, I have following skills - Lead Generation [login to view URL] - Linkedin Message Marketing [login to view URL] Flere

$36 SGD in 3 dage
(4 bedømmelser)
3.5
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 Flere

$31 SGD på 1 dag
(20 bedømmelser)
3.6
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 Flere

$36 SGD på 1 dag
(4 bedømmelser)
2.2
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 Flere

$17 SGD på 1 dag
(5 bedømmelser)
2.3
$12 SGD in 3 dage
(2 bedømmelser)
1.6
Cobse

Hi. I can help you with this but this step 3 needs more detailed explanation. I can do this in a couple of hours. "3) copy data from columns A-C:E-F into the new row created below, the column D in the new row sh Flere

$27 SGD på 1 dag
(1 bedømmelse)
1.0
$36 SGD på 1 dag
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
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 in 2 dage
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
0.0
$12 SGD in 3 dage
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
0.0
kimcodilla

Hello, Good day! I have read the project description and was able to understand what the project is all about. I have a sound understanding when it comes to EXCEL VBA, C#, and/or VB.NET. I have finished the Flere

$26 SGD på 1 dag
(0 bedømmelser)
0.0
$27 SGD på 1 dag
(0 bedømmelser)
0.0
emadkhz91

hi there. i made your VBA program as i love programming. some part of the codes mentioned below. and this is a screen from Excel [login to view URL] i can give you the file anytime you want. regards Flere

$21 SGD in 0 dage
(0 bedømmelser)
0.0