So, I've got some audit forms built on excel, they are used to grade/audit phone calls. The forms include questions with push buttons, check boxes, and drop down lists with a running score down one side.
At the top I copy and paste a line of data, which in turn auto fills some of the form.
However, the form being used depends on the type of phone call. So sometimes, I copy and paste in the data, and then realized it's the incorrect audit form.
Is there a way to program it so that when I paste the line of data at the top, the form changes to reflect the necessary call type?
So for example: If A1="Contact", the remaining worksheet is updated to the Contact Form? If A1="Voicemail", the remaining worksheet updates to the Voicemail form?
I can't attached the file, so I'm hoping someone can understand my description.
Bookmarks