I am using a spread sheet which contains a number of combi boxes (approx. 30)
Once I've selected all requirments in these combi boxes, I run a macro to
copy the selections to another sheet. I then need all the combi boxes to
return to their previous/original selections, ready to start the process
again.
I tried to record a macro to return them all to their original selections
but its not recording any of my 30 selections. It takes far to long doing
this manually each time. Thanks for any suggestions