Insert Copied Cells multiple times, shift cell down

hi
i have data with up to thousands of rows down, there's a blank row in between them, and now i like to enter sub info using =formula in that blank rows, its going to be the same sub info for all line, but this sub info can go up to 1000 rows

at the moment i can copy this sub info from the 1st line and insert copied cell in the 2 blank row with shift cell down, no problem, works great but not so great if you have thousand of line to be inserted with this sub info, i'm talking about almost ten thousands, probably going to take over 3-6 months to do this,
can anyone please help me here

option that i thought might help: create enough space(if 900 rows needed than insert new 899 rows in between? 899 blank rows x lets say(1000 main info) so i can paste multiple times? that still going to take months

please help

everything from row 2 to row 29 is a sub info that need to be copy underneath main info

thank you thank you thank you

thank you very much, i have plenty of document need to done like the one i attached, i start to see some light i can finish it now,
bad news is i am not fimiliar with macro, never use that feature as a matter of fact, is it possible you give me a step by step instruction to apply your suggestion??

again thank you very much

in a =a1, =b1, =c1 format or 1 2 3?i should leave only 1st sub main info

since you tested with 100 sub main, what happen if i want to copy it 1000, 1001, 6327(any number basically) do i need different macros?

thank you

hi rollis13

what if i paste the sub info first the the main, sound simpler, what do you think?

lets say i have 3000 main info means 3000 sub info, i copy the main info first 3000x times, then ( or first) put a row in between them, when its done the i paste the main info, of course the sub info will be all 0 0 0 until i enter the main info

or should i do what you suggest me bit by bit so the system wont crash, says 100 main info each time?

thank you

hi rollis13

what if i paste the sub info first the the main, sound simpler, what do you think?

lets say i have 3000 main info means 3000 sub info, i copy the main info first 3000x times, then ( or first) put a row in between them, when its done the i paste the main info, of course the sub info will be all 0 0 0 until i enter the main info

or should i do what you suggest me bit by bit so the system wont crash, says 100 main info each time?

thank you

hi rollis

can i use the macro above if my main info is more than 8 numbers (column h)?? it can go up to 24 numbers, do i only to edit it a bit? where?

thank you

hi rollis13

i understand that main info just need to be more than subinfo (in this matter more than 6 numbers) , thanks for that, but what if the subinfo is more that 6 numbers? in example below (9 numbers) what changes need to be make?

example

main: 1 2 3 4 5 6 7 8 9 10 11 12
subinfo 1 2 3 4 5 6 7 8 9
1 2 3 4 5 6 7 8 10
1 2 3 4 5 6 7 8 11
1 2 3 4 5 6 7 8 12

main info more than 8
subinfo more than 6

what changes need to be make?

kind regards

hi rollis13

thank you very much, i really appreciate it, you really have help someone

kind regards

Glad being of some help .

hi rollis13

i have 1 more question please, example attach

after all subinfo are being paste, i like to combine or merge those subinfo cells in to 1 cell using =A2&" "&B2&" "&C2&" "&D2

and copy it down but only the subinfo cell, double click on the + does help, but the process stop because of the empty row
right, i actually don't need an empty row, and yes you've told me how

the question is

if there's no empty rown in between, can i paste those merging formula but skip every 16th row(main info)

but i like to do this after i apply the macro

i know if only i don't need to skip the main info and no empty row blocking, i can paste the whole thing in a single click

or maybe after, i can copy the result and paste it to a new document and the delete every 16th row there??

kind regards

never mind about the last question, i include the merging formula in the macro and work perfect

thank you very much

@ system

Welcome to the forum.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Hi System,

A simple way of doing this thing is,

first copy and paste complete data as it is in the second sheet,now in second sheet give the formula =if(sheet1!a2>=1,sheet1!a2,sheet1!a1). in one blank row type sub info. now copy the formula then paste using this combination shift+cntl+end, the select one column and then paste. then copy entire sheet and paste as value. work is done.

hi solomon14all

can you please rephrase your instruction

thank you