Friday, 8 September 2017

microsoft excel - Delete only certain Rows

I have a spread sheet which in column A I place a Y when I invoice the line. I wish at the end of the month to delete ALL Rows with a Y in column A only, then move all rows up so there are no blank lines in the spread sheet. How is the quickest way to do this as I have 26 separate spread sheets I need to do it in every end of month?

No comments:

Post a Comment

Where does Skype save my contact's avatars in Linux?

I'm using Skype on Linux. Where can I find images cached by skype of my contact's avatars? Answer I wanted to get those Skype avat...