Moving Data Question

S

Skip

I have five rows of data, representing five weeks of information.
I would like to delete the oldest info (week 5), and move the other
weeks up.
And then enter the new info for week Any help appreciated.
 
P

pdberger

Skip --

1) Start the macro recorder, and give the series of steps you're going to
follow a convenient name (such as Ctrl-M, for "move the data").
2) Select the final four weeks of data. Cut it, and move it up one row.
Paste it. (This will open up the final row of data, without upsetting any
formulas that may be keying off this info.)
3) Stop the recorder.

HTH
 
Top