Delete and Shift Cells up
Hi all,
I'm trying to create a macro that will start at the very first cell, I guess
A1, and work it's way down, and will check the value of the cell. If the
value of the cell is not equal to the word "Sales" then delete that row. but
if it finds the word sales then stop the process.
Also can I have this macro be able to autorun on the save of the doc? For
instance if I save an email attchment that is an excel file will it run when
I save the attachment without opening the file and then saving it? So to be a
little more clear if I right-click on the excel attached file in the email
and click save, can i have this macro run?
|