How to shift data from one table to the other

[NotQuiteThereYet]

Hello,

I have 2 tables in a worksheet, one is "Actual" data (Historical) the other is forecast data. Is there a way by using Todays date to transfer data from forecast to actual, ie. On Monday, Tuesdays data is "forecast" but on Tuesday, Tuesdays data becomes "actual". Note that in the tables, there is no cell containing the actual date. Hope that makes sense and once again any assistance (even if a plain "That's impossible") will be gratefully received.

 

[sheetspread]

It's just a short VBA macro to conditionally cut and paste. Only the cells under current or past dates will be moved. I'll try to figure something out from the available code samples online, but hopefully a real programmer here will post something first.