Question about automating an excel file

[Richard Hendriks]

Hi
I am new on this forum and want some help.
I am working on a single excel file using for a customer questionnaire, I want to use the Save As button (with a macro) to save the results in another sheet of the same file and at the same time empty the results in the Questionnaire.
Besides that I also want that if we have results for that specific client it will not appear anymore in the dropdown menu.

Is there anyone who can help me.

Many thanks
Richard

[Alf]

Perhaps something similar to this

Please Login or Register  to view this content.

Alf