Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Teo
 
Posts: n/a
Default Rolling Budget

This is kind of complicated.

In one sheet we have a rolling income statement (Jan-Dec) in which we enter
the figures for the actual month manually (this is the input sheet).

In second spreadsheet we have a similar rolling, but with budgets figures.

The third sheet only refers to the current month and it reads from both of
the sheets above; we only want to show the current month figures here.

For example if the current month is March, we want the third sheet to read
the figures corresponding to March from sheet one and the figures
corresponding to March from sheet two for the budget.

When I open sheet one to enter April figures, I want to see the numbers in
sheet two and sheet three change to the corresponding April figures without
copying cells.

What will be good here?
 
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
Divide Monthly Sales Budget to Day Budget Benedikt Fridbjornsson Excel Worksheet Functions 2 January 10th 06 03:42 PM
Budget vs. Actual Stanley Excel Discussion (Misc queries) 0 December 16th 05 08:59 PM
Finding y-Values in budget curve app w/ excel James Gross IV Excel Discussion (Misc queries) 2 September 12th 05 02:21 AM
Finding y-values in budget curve app with Excel & VBA James Gross IV Charts and Charting in Excel 3 August 16th 05 04:41 PM
Find and Replace miket_jam Excel Discussion (Misc queries) 3 January 27th 05 02:15 AM


All times are GMT +1. The time now is 06:02 PM.

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

About Us

"It's about Microsoft Excel"