Help with optimizing a dataset

[george_k]

Hi

I've attached a file that is the result of a product forecast.

What I'd like to do is minutely adjust the data in B4:K12 so that the totals shown in blue colour on Row 15 and Column O are respected.

What would be the way to go about doing this?

Book1.xlsx

[NeedForExcel]

Use this in O4 and Copy Down.

Hope this is what was required, on what I could understand from your above post

=ROUND(M4,-1)

Deep

[NeedForExcel]

Oooopppsss.. Sorry for the Incorrect answer.. Now I understand the problem.

You basically want to alter the data to Match the Target in Column O without disturbing the Totals in Row 15?

[george_k]

Yes, that's exactly it, I'd like to match the annual totals in row 15 while at the same time ensuring that the overall result for each Product match the totals listed on Column O.