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
