Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET

Use the large white space in the body to describe what you want done.


Gord Dibben MS Excel MVP

On Sat, 30 Aug 2008 12:31:00 -0700, mike64149
wrote:


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET

I am making a monthly budget, tracking it daily, used my formulas to move
data to different spred sheet. Data changes daily, always spend more. I would
like to keep yesterdays #s while using the addional amount added for todays
#s. I am tracking 5 different catagories and expenditures for each. Set up
the daily/monthly template but I know the data will update across the
spredsheet and not stay for the day assigned.

"Gord Dibben" wrote:

Use the large white space in the body to describe what you want done.


Gord Dibben MS Excel MVP

On Sat, 30 Aug 2008 12:31:00 -0700, mike64149
wrote:



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,389
Default HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET

You want a pivot table.

Enter all your data in one sheet. Then use a pivot table to calculate the
summaries you want (ie, sum of each category each day).

Debra Dalgliesh has the most comprehensive information on Pivot Tables.
Start he http://www.contextures.com/xlPivot02.html

You won't ever be sorry you learned pivot tables.

Regards,
Fred.

"mike64149" wrote in message
...
I am making a monthly budget, tracking it daily, used my formulas to move
data to different spred sheet. Data changes daily, always spend more. I
would
like to keep yesterdays #s while using the addional amount added for
todays
#s. I am tracking 5 different catagories and expenditures for each. Set up
the daily/monthly template but I know the data will update across the
spredsheet and not stay for the day assigned.

"Gord Dibben" wrote:

Use the large white space in the body to describe what you want done.


Gord Dibben MS Excel MVP

On Sat, 30 Aug 2008 12:31:00 -0700, mike64149
wrote:




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 132
Default HOW DO I FREEZE DATA THAT CHANGES DAILY. dAILY/MONTHLY BUDGET

I have a list of monthly budget amount, fund amont as on a day and some
incomining funds . Question1. What is the formula for calculating the
elapsed number of days to return
in c1 for a budget value of a month which is in a cell a1 and a given date
in b1 and available fund in d1. In an instance, for Sept 2008 and Oct 2008
the Budget reserved as 2900 and 3500. If available fund is 1200 on 27 sept
2008 the fund will last 4 days (as per day Avg. for sept is 96.67) + 7.2 days
in Oct (at Oct Avg of 112.90) I need to return Answer as 11.2 days
Question2. What is the formula for calculating the spread number of days for
an available fund in d2 to return
in c2 for its next following month budget which is in a cell a2 where the
day calculation to be
continued from the c1. The Budget amount for October 2008 will be 3500, the
Available fund 6000. The same like above the formula required is the total no
of days but continued from the above resulted day (which ends on 8th Oct
2008).

"Gord Dibben" wrote:

Use the large white space in the body to describe what you want done.


Gord Dibben MS Excel MVP

On Sat, 30 Aug 2008 12:31:00 -0700, mike64149
wrote:



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PMT: Daily interest compounding; monthly payment rkhughes Excel Worksheet Functions 10 April 3rd 23 07:44 PM
Linking Daily Worksheet To Daily Invoice Total KJames Excel Worksheet Functions 1 March 18th 07 12:01 PM
Collecting weekly and monthly totals from daily data Kasper Excel Worksheet Functions 0 January 12th 06 09:02 PM
Daily,monthly total nowfal Excel Discussion (Misc queries) 3 September 26th 05 09:33 PM
summing up daily data in a monthly compilation mark_vi_ Excel Worksheet Functions 2 June 22nd 05 01:07 AM


All times are GMT +1. The time now is 05:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"