My scenario:

I have Company Profit and Loss with 200 Rows of account number and names in
A1-200 with actual and plan figures in B and C 1-200.

Whilst in E-G 1-150 I have a P&L with account number/names and actual and
plan figures for a profit stream. But the company account number/names dont
match up on the same row as for the total company as not as many accounts has
been used.

I was wondering if there are any method of aligning the accounts and
connecting figures for the profit stream with the rows in the company P&L.
There would ofcourse be 50 blank rows on the P&L for the profit stream, but
all the Rows would match up so for example the TOTAL would be on row 200 for
both the company and the profit stream.

--
Regards Anders