Split one row into two on another worksheet

[bowlow77]

Hi

I have created a excel document with multiple sheets on the final sheet I’ve tried to create a report that pulls information in from the following worksheet and I though I had it nailed however now that I’ve entered data I’ve found that the report is not working as expected. I have meter readings for black and colour along with a whole host of other info on one row in the worksheet on the report I wanted to break this down into two rows this I’ve managed to do but as I’ve dragged the formulas down the pages its missing every 2nd and 3rd line for the first worksheet is there a way around this or am I going to have to spend an age doing this manually?

Thanks for you time in advance

[mrchoppychops]

can you post a sample workbook?

the mods probably wont like your title either its a bit vague...

[arthurbr]

Mrchoppychops, I agree with both of your sentences ...

[bowlow77]

Hi I've changed the Title and posted a workbook thanks for the advice
As you will see from the formula's I am trying to split row 2 from the summary page into two rows in the report page then row 3 into two etc etc spliting Mono and Colour reading making it easy to read when printed.