C
citybeing
Hi,
Not sure this is possible, but I'm trying to do an IF/THEN statement in
a macro. So, if a certain row has a number less than one in column A,
then skip; if a certain row has a number of 1 or more in column A, copy
these respective row and paste them all over top of the existing data.
Basically, I'm trying to track a series of bonds, and once the bonds
exprire (the days to maturity is less than one), I want to eliminate
them from the list, while moving up all other current outstanding bonds
so the list has no blanks.
Is there a way to do this in a macro? I'm not sure where to start.
Thanks for any input!
Not sure this is possible, but I'm trying to do an IF/THEN statement in
a macro. So, if a certain row has a number less than one in column A,
then skip; if a certain row has a number of 1 or more in column A, copy
these respective row and paste them all over top of the existing data.
Basically, I'm trying to track a series of bonds, and once the bonds
exprire (the days to maturity is less than one), I want to eliminate
them from the list, while moving up all other current outstanding bonds
so the list has no blanks.
Is there a way to do this in a macro? I'm not sure where to start.
Thanks for any input!