VBA or Macro needed for Copy yesterday's data automatically

[krjoshi]

Hi Folks

I need a Macro or VBA to copy paste yesterday's data into another sheet to compile with today's data.

I have attached an excel file of what I'm trying to accomplish.

Thanks in advance for your expertise!

Joshi

[dangelor]

Possibly...

Sub Update()
    Dim vData As Variant
    
    vData = Worksheets("Today").Range("D5:E8")
    Worksheets("Yesterday").Range("B5:C8") = vData
End Sub