I have budget information to be imported as text to my financial suite. The
date data (which remains the same) is on row 5 columns 'R' to 'AC'.

The data on rows 7 to 107 are individual ledger accounts related to the 12
months in R5:AC5.

I use =INDEX(ATWS!$5:$5,ROWS($1:$18)) to copy down the dates and
=INDEX(ATWS!$7:$7,ROWS($1:$18)) for each months budget for that line
(account).

I need to do this every twelve lines for each account. I do this over
several business units so there is a lot of data (100 lines x 12 months).

Is there a way I can have formulas populate the text import data sheet
automatically for each change in account number without having to copy twelve
formulas down and change the references manually.

We reforecast our budgets each quarter fro the remainder of the year so I
will be very grateful if anyone can help.

Cheers

--
Jim