Write a script / automate Microsoft Excel

I am looking for someone to write a script for Microsoft Excel which I can use do remove specific rows and columns from a spreadsheet. It needs to work on a Mac computer. Please watch this screen recording video where I explain exactly what I need

https://www.dropbox.com/s/qdee21mm89zh9n1/Script%20for%20Numbers.mov?dl=0