Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
Need formula to add a set amount to a balance on a specific date | Excel Worksheet Functions | |||
Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) |