Macro

[Amolivy]

I work in a company where I raise order for customers.
There's this file that has all names of customers used by SalesReps to order for the customer but from where we download, it comes with all customers both those who has request and those that don't.
Now some rows of some customers don't also has a request, thereby leading me to start hiding columns.
Now, my problem, how can I get a VBA to always run it for me. Checking is this column empty=yes then hide or no then don't. Since the number of customers that may come at a time varies.
Thanks. Any help will be appreciated.

 

[mole999]

create a small sample file with fake details and load to a well recognised cloud file that dosen't need an account, and someone may look at it. bring the link back here. Makes sure the headings are exact match for what you see