Copy dynamically

[BlackEyed]

I'm trying to find out how I should solve the following without vba.

In sheet 1

A
1 text 1
2 text 2
3 text 3
4 text 4
5 text 5

In sheet 2 sheet 1 18 times repeated

A
1 text 1
2 text 2
3 text 3
4 text 4
5 text 5
6 text 1
7 text 2
8 text 3
9 text 4
10text 5
11text 1
12text 2
etc

If sheet 1 changes as follows:

A
1 text 1
2 text 2
3 text 3
4 text 4
5 new item
6 text 5

Sheet 2 has to repeat again 18 times, but then with the new data.

Any help is highly appreciated!

[ChemistB]

Assuming your singular data will be in column A Sheet1 rows 1 to 20 and your secondary data is on another sheet, also starting in row 1. Try this equation

Please Login or Register  to view this content.

Dragged down. Does that work for you?