I have Objects on my sheet designed as per customer required formatting. I then manually use a list box to select the customer, when exported, I then select the next Object and go back to the list box and select the next customer.
I would like to automatically select the list box when the Object has been selected. Is this possible with a Macro?
If this has been asked before, sorry must have missed the post.