Help to fill down transpose array formula in intervals.

**LAR23** · 09-10-2013, 01:47 PM

I am trying to speed up mass data entry into a workbook containing multiple sheets.

My reference data is contained in a sheet labeled DC. It has averages in columns that I have been transposing into master data sheet with the following formula

=TRANSPOSE(DC!AF4:AF12)

I am trying to fill down the following formula in the master sheet, but I can't figure out how to have it fill in intervals of 10. I want to be able to enter my data on the DC sheet and have the averages automatically fill on the the master sheet. I have hundreds of lines of data to enter and not having to change the formula for every line would help.

So it should fill as follows.
=TRANSPOSE(DC!AF4:AF12)
=TRANSPOSE(DC!AF14:AF22)
=TRANSPOSE(DC!AF24:AF32)

Any help is appreciated.
Lindsay

**martindwilson** · 09-10-2013, 02:07 PM

try
=INDEX($AF$4:$AF$1000,COLUMNS($A$1:A1)+(ROWS($A$1:A1)*10)-10) and =INDEX($AQ$4:$AQ$1000,COLUMNS($A$1:A1)+(ROWS($A$1:A1)*10)-10)

**LAR23** · 09-10-2013, 05:24 PM

Thank you so much!

I just had to include the sheet name, increase the range and it filled down in a snap. I appreciate the help, you've saved me a lot of time.

Thanks again

**arlu1201** · 09-11-2013, 06:34 AM

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.