Read a number in a cell and copy row n times

Closed
Report
-
 DidYouEvenSearch -
Hello experts,

I will try to explain as good as i can my problem.
I'm working in sheet 2, and my heading is 5 rows.
I would like to find a code that when there is a number in a cell in colum F ( starting from F6) he reads that number and copies the entire row to sheet 1 a number of times like the cell says. ( in sheet 1 i have a heading of for 3 rows so the first line must start at A4)
each time there's a new line in sheet 2 he copies that line underneath the last one in sheet 1.

I hope the sample explains a little bit my problem


If it is possible could you make this with a button, so when i hit the button he will execute what i just explained.

Sheet 2 A B C D E F G
5 Heading
6 screening AB Gitzels 2 40
7 satellite FvdG Gitzels 4 150
8 ...
So the code reads F6, F7,... and copies that number a number of times the row from column A to column U in sheet 1. Start with the first line on A4, like in this sample. Nice underneath eachother.
Each time I add a line and I filled in the number of trials I would like to have like below.

Sheet 1 A B C D E F G
3 Heading
4 screening AB Gitzels 2 40
5 screening AB Gitzels 2 40
6 satellite FvdG Gitzels 4 150
7 satellite FvdG Gitzels 4 150
8 satellite FvdG Gitzels 4 150
9 satellite FvdG Gitzels 4 150
10 ...
11

Thank you for youre time.
Great appreciation.

GJ

1 reply


https://ccm.net/forum/affich-508094-copy-rows-n-times-and-then-fill-a-series


Would help in anyway? Its essentially the same thing.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month