Hello,
I have a Word template locked for filling in forms and a spreadsheet with data that corresponds to each field. What I want to happen is for when the user enters a word/string in the first text form field that matches what is in spreadsheet (eg column B) it will fill in the remaining text fields from that row (probably on the Run macro on exit command) else if the word/string cannot be found it will return an error message.
I can upload example template & spreadsheet if needed.
Thanks
fra