Inserting actual sales next to budget - issues with new cust/ items with 2 dynamic col

Hi There,

Thanks guys this is just fantastic , that's a great help.

If I may add one more variation to it . I need both the "Sales$" and the "Qty" to be dynamic- pls refer to sheet 2.

This will save me one week of work with over 20,000 actual sales line items and potential errors when inserting new customers/ items and sort.
Thank you very much . This is marvellous.

Regards
Rcaus