LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel 2003 month to month data change grid

I have a 2-sheet workbook with one see being an overview with formulas
in it. The second sheet is raw data in 8 columns that I pull every
month. My question is:

How can I make it so that each month, when I paste in the new data,
the front sheet's formulas automatically adjust to the amount of data
I paste into the raw data sheet? I am an intermediate user (at best),
and would need a little help on how to set it up so I can just plug in
the numbers each month.

Thanx,

KMQ
 
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
Retrieve data for previous 3, 6, 12 month given current month GB Excel Worksheet Functions 4 July 19th 07 11:58 PM
Compare month to month data GP Excel Worksheet Functions 1 December 29th 05 10:01 AM
How do I set up 12-month rolling month cells in excel? jbh Excel Discussion (Misc queries) 2 November 30th 05 08:12 PM
=Month function in Excel gives incorrect month jbmx New Users to Excel 1 September 14th 05 07:58 PM
show month number as month name in Excel? Phil Hart Excel Discussion (Misc queries) 3 June 20th 05 06:12 PM


All times are GMT +1. The time now is 05:13 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"