View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chad[_2_] Chad[_2_] is offline
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