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 |
All times are GMT +1. The time now is 08:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com