Copy a Range multiple times

**alocke** · 11-16-2011, 04:22 AM

Hi all,
I have a large set of data which is present from A1:BZ199.
I want to copy this array into the row below - arr(1) would therefore be A201:BZ399 etc etc.

In cells A1,A201,A401 etc. I need values taken from A1, A2, A3 in 'sheet2" to be placed in them.

- I can sort of do the first bit, but my code is long and unecessary, you guys probably know a better way of doing it.

Thanks in advance guys,
Alex.

**Domski** · 11-16-2011, 05:04 AM

So do you want to repeat this the number of times that there is an entry on Sheet2?

Dom

**tom1977** · 11-16-2011, 05:12 AM

maybe you can use this code

x means times to copy

Please Login or Register  to view this content.

**alocke** · 11-18-2011, 12:29 AM

Hi guys, sorry for the late reply,

Tom's code is what I wanted to achieve although the part I wasn't sure how to do was the additional part. If I perform tom's code the cell at the top of each range I want to contain the title of the dataset. These titles are on another spreadsheet labelled "sheet2".

The reason I can't input it manually is because these titles on sheet two are set up so that the whole dataset will change when the title changes. So for example, A4 on "sheet1" is to be replaced with the value in A8 on "sheeet2", cell A204 on "sheet1" with cell A9 on "sheet2" etc etc.

Does this make sense?

Thanks for the help guys,
alex.