Hi guys, the revenue side B8-B14 is fine....however, cells B22-24 don't seem to work. The whole thing then falls apart from B30 to B43 and just reports the totally incorrect figures. They should literally be line to line the same as the ones in the "YTD" column of the "UK P & L" sheet.

From B54 to B91 i don't know what formula to put in place, but those cells should drag through the corresponding numbers from Column B in the "UK balance sheet accounts" tab, using INDEX and MATCH similar to the formulas in place in the Column C of the "Consolidation schedule" tab.

Sorry if it wasn't clear before, hope it is now. This is a complex worksheet I agree, causing me pain on a Monday! Thanks again for looking at it and any help.

Roger.