View Single Post
 
Old 02-09-2018, 11:20 PM
dylansmith dylansmith is offline Windows 8 Office 2013
Optimizer
 
Join Date: Nov 2011
Posts: 144
dylansmith is on a distinguished road
Default Automate Job application word doc to Excel (with data validation)

how difficult is it to achieve and how reliable will the method be?

Most importantly, I'd also like to know how to validate data for various fields within Word (e.g. date of birth cannot be >70 years old, salary <$20,000, each employment period cannot overlap with one another for different roles), and then populate these fields in Excel for further analysis next time.

In addition (but off-topic), It will also be a bonus if there's a more secure method of storing sensitive information other than Google forms, especially for job applications (without resorting to enterprise-level solutions).

I look forward to hearing from you soon. Thanks!
Reply With Quote