Hi there,
I am hoping there is an easy way to set up a form to pull up an existing row within a worksheet based on the user selecting the specific one from a pull-down and have the current row data be populated in the form and permit the user to either change or add details and them apply it to the workbook.
Here is the scenario.
There is a workbook that contains all of the information we are interested in regarding a potential interviewee for a specific position.
-
Some basic information is entered for candidate to be interviewed. It consist of their name, resume, email, and phone number. The phone screener is notified there is a candidate to be screened.
-
The screener arranges a phone interview and needs to pull up the basic information previously entered and conducts the phone screening. During this screening additional details are collected and added to the workbook row for this specific interviewee. The phone screener completes the interview and flags the results which either pushes the candidate to the next phase of interviews or the interviewee row is moved to another workbook as being “declined”.
If I can figure out how to do this, then the other steps will be easy to figure out. I would appreciate any guidance or advise.
Sincerely,
Tom.
