had1015
09-03-2016, 03:49 PM
Hi,
Thanks you for all the assistance you've provided and continue to provide. I have customer names listed in column D on the Master sheet. They are listed as last names comma space and first names. I would like to have a macro which would copy the Master worksheet, ask the user to input the one or several customer last names only separated by comma and the next customer last name and delete all other non blank rows in column D starting from row two to the last row. The number of input names may be anywhere from one to twenty. The number of rows may change each day. Any assistance would be greatly appreciated.
Thanks you for all the assistance you've provided and continue to provide. I have customer names listed in column D on the Master sheet. They are listed as last names comma space and first names. I would like to have a macro which would copy the Master worksheet, ask the user to input the one or several customer last names only separated by comma and the next customer last name and delete all other non blank rows in column D starting from row two to the last row. The number of input names may be anywhere from one to twenty. The number of rows may change each day. Any assistance would be greatly appreciated.