| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Update of Data... help please
Hello,
I am preparing a MIS for my comp. I have a problem here. I have a monthly sheet and a daily sheet. Daily sheet is upated on a daily basis. now on the first day, both daily and monthly will have same numbers. On the second day I want the monthly to be -- First day data + today's daily data.... Is that possible...... Plz help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Update of Data... help please
Yes, but without specifics, it's difficult to be sure the answer I give you
will be a good one, but I'll try. Assume daily totals on the 'Daily Sheet' are in column B and there is one entry per day using rows 2 through 32. On the monthly sheet a formula like =SUM('Daily Sheet'!B2:B32) will give you the total for the daily entries. "Nemo" wrote: Hello, I am preparing a MIS for my comp. I have a problem here. I have a monthly sheet and a daily sheet. Daily sheet is upated on a daily basis. now on the first day, both daily and monthly will have same numbers. On the second day I want the monthly to be -- First day data + today's daily data.... Is that possible...... Plz help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pie chart data labels auto update ? | Excel Discussion (Misc queries) | |||
| Auto Update Linked data | Excel Worksheet Functions | |||
| Macro Auto-update of data labels | Excel Worksheet Functions | |||
| How to auto update a spreadsheet with data from a .xls file? | Excel Worksheet Functions | |||
| Sharing data between worksheets (auto-update) | Excel Discussion (Misc queries) | |||
Linear Mode
