I do a daily report and on ti i have created a button that saves the file using todays date to a location on a network drive .
Private Sub CommandButton10_Click()
ActiveWorkbook.SaveAs ("N:\...\Daily Reads\Report_Day_" & Format(Now(), "YYYY-MM-DD") & ".xlsm")
that works fine what I would like to do is when i create a new workbook tommorow i want it to get a couple of figures from yesterdays report so that i can do a calculation
e.g we have a figure for total water use so yesterday may be 8796 litres and todays may be 9321 litres , I would like to get yeterdays figure subtract it from todays and get a daily usage.
I have tried
='("N:\...\Daily Reads\[Report_Day_" & Format(Now(), "YYYY-MM-DD")-1] & ".xlsm")Plant Daily'!$c$35
but it throws a ref error.
thanks in advance