Hi everyone,

First post here. I am trying to build an amortization table, problem is I have to link it to my CF statement. The amortization is monthly, and I have just added a cloumn next to it with the year summaries, problems I have now are:

1 The years summary come every twelve cells, so the table for year summary is huge, is there any possible to do another table, referencing only every 12 cells?

2 Amortization is in horizontal as I have 240+ entries, but would like my financial statements in horizontal for ease of read. The only way I can think about it (besides manually) is transposing it, but that way I will lose the references, any clue about how to go about this?

Thanks!