Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving Data Question
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving Data Question
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 "Skip" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Question about graphing four sets of data | Charts and Charting in Excel | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |