date specific formula
 

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?

date specific formula
 

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"jdvanhemert" wrote in message
...
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?