If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Column Data to Rows
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 |
Thread Tools | |
Display Modes | |
|
|