I am looking to create a excel sheet for a order vs sales for my business.

Part of this sheet, I am attempting to create a formula which will auto populate the last 4 weeks of ordering and sales differentials so I can get a monthly summary for the last 4 weeks of how we are performing.

However, I am struggling to do this. I can attach my screenshots of my workbook to help understand.

I am continuing the base template further down and just aiming to create a simple formula for the bottom right table which will choose the 4 latest weeks worth of summary and will auto populate with all the data

​I am looking to create a excel sheet for a order vs sales for my business. Part of this sheet, I am attempting to create a formula which will auto populate the last 4 weeks of ordering and sales differentials so I can get a monthly summary for the last 4 weeks of how we are performing. However, I am struggling to do this. I can attach my screenshots of my workbook to help understand.I am continuing the base template further down and just aiming to create a simple formula for the bottom right table which will choose the 4 latest weeks worth of summary and will auto populate with all the data   Read More

​