date specific formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sheet where I am updating month-to-date numbers each day. In other
words, I do not have access to the totals for each individual day, only the
total sum of all the days of that month so far.

Is there a way I can craft a formula (or a macro, though I am not good with
those yet) that will copy new month-to-date information to a separate sheet
once I replace it day to day?
 
You want Sheet2 to show a value from Sheet!?
Use =Sheet1!A1
If the sheet name has spaces you need to use single quotes: ='June Data'!A1

best wishes
 
Back
Top