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
|