If you can do it in Excel, you can probably automate it with a macro. To use a macro, you first need to record it. You perform the sequence ... you can run it again at any time.