IRR calculation across two worksheets

[cnishimoto]

I have 30 years of cash flows (by month) of which I want to calculate
an IRR. Excel only has 256 columns. Is there a way to calculate the
IRR on this cash flow if it continues on to a second worksheet?

Any insight is greatly appreciated!!!

 

[Myrna Larson]

You need to change the orientation so the data is in a column instead of two
rows on different worksheets.

Edit/Copy the 1st row, select a blank cell below or in another workbook and
Edit/Paste Special and select the Transpose option. Copy the data from the 2nd
sheet and paste it below the first.

The other option is to use Quattro Pro, which allows more than 256 columns.

 

[Bas Mekel]

Hi Cnishimoto,
I don't know anything about an IRR but it's possible to make formula's
who refer to value's/formula's on another sheet (for example:
=Sheet1!A1+Sheet1!B1). Perhaps it's more neat to create a custom VBA
function so that you don't need so much columns? I depents on how you
exactly want it to be.
Hope this helps!
Regards,

- Bas