Copy/Move question

[Bruce LeBlanc]

Several time a day, in an Excel 97 workbook, I move a short list of numbers
upwards in a column. To accomplish this, I highlight the existing numbers,
then copy them starting with the first blank cell. I then return to the old
numbers and delete them. I do not use the "move" function because it
destroys the related "index/match" formulas in the columns to the right. Is
there a way to have the old numbers disappear automatically (as in a move)
when I use the copy function?

 

[Dave Peterson]

How about a macro that does what you want.

Record it when you do it manually and then if you have trouble generalizing it,
post back with some more details.

 

[dvt]

Several time a day, in an Excel 97 workbook, I move a short list of
numbers upwards in a column. To accomplish this, I highlight the
existing numbers, then copy them starting with the first blank cell.
I then return to the old numbers and delete them. I do not use the
"move" function because it destroys the related "index/match"
formulas in the columns to the right. Is there a way to have the old
numbers disappear automatically (as in a move) when I use the copy
function?

Another possible suggestion. Have your "related index/match formulas" refer
to a named range. Use the OFFSET, INDEX, and/or MATCH functions in the
definition of those named ranges. Now you can cut 'n paste (or move) as you
wish, since the named range will automatically update according to the
available data points.

Dave
dvt at psu dot edu