Updating Excel Data from another spreadsheet

Hi All,

I have included the spreadsheets below.

So in workbook 1, on Cell L15 we have a calculated % DT (Downtime) Due to Engineering column which is calculated using FILTER and SUM functions.

It would be great if I could get this figure pulled through weekly into Column C of Workbook 2, starting with Cell C175 being this current week (Week 16). When the number in Cell D15 is refreshed weekly I would like it to add the new number over into the Column C (Week 17, 18....)


Thanks for the Help,
Joel

This is from another thread which I was told was the wrong one. I was given a piece of VBA code which copied the value over leaving a number in place rather than a referenced number from Workbook 1.