KMik
10-29-2015, 11:51 AM
Hello,
I've searched the internet lands for a macro that could take over 400 job descriptions and move their different sections from WORD into excel. Essentially I want all of the job descriptions (which all have similar headers in Word), to have different columns per section and pull the data from word under those sections.
For example:
Title: RN
Cost Center: 4356
FLSA: Non-Exempt
Summary
Paragraph here of the summary of the job
Minimum Qualifications
1. Must possess a current license to practice professional nursing in the Commonwealth of Pennsylvania.
2. Certification by the American Association of Nurse Anesthetists (AANA).
3. Graduate of an accredited school of nurse anesthesia.
Preferred Qualifications
1. Previous experience in a Charge or supervisory position.
Essential Functions
1. Exemplifies St. Clair Hospital’s Customer Service Behavioral Expectations in all interactions. Treats customers with respect, compassion, and hospitality; anticipates, identifies, and responds to individual needs; makes a positive first impression by acknowledging customers; and demonstrates flexibility while maintaining priorities.
2. Under the supervision of the manager, prepares and maintains the CRNA work schedule assuring adequate staffing levels to cover all areas of the anesthesia service.
Title
Cost Center
FLSA
Summary
Minimum Qualifications
Preferred Qualifications
Essential Functions
RN
4356
Non-Exempt
Paragraph here of the summary of the job
Must possess a current license to practice professional nursing in the Commonwealth of Pennsylvania
Previous experience in a Charge or supervisory position.
Exemplifies St. Clair Hospital’s Customer Service Behavioral Expectations in all interactions. Treats customers with respect, compassion, and hospitality; anticipates, identifies, and responds to individual needs; makes a positive first impression by acknowledging customers; and demonstrates flexibility while maintaining priorities.
Certification by the American Association of Nurse Anesthetists (AANA).
Under the supervision of the manager, prepares and maintains the CRNA work schedule assuring adequate staffing levels to cover all areas of the anesthesia service.
Graduate of an accredited school of nurse anesthesia.
I have attached a copy of a job description, where most of the 400 job descriptions have the same format. Is this even possible, especially with the bullets for essential functions and minimum qualifications? We are converting to an online system and it'll be much easier to upload into the system from excel. Any help would be REALLY appreciated!
I also would like for the macro to see that there are 400 job descriptions within a folder and do it automatically without having to open up all 400 job descriptions.
Thank you so much in advance!
I've searched the internet lands for a macro that could take over 400 job descriptions and move their different sections from WORD into excel. Essentially I want all of the job descriptions (which all have similar headers in Word), to have different columns per section and pull the data from word under those sections.
For example:
Title: RN
Cost Center: 4356
FLSA: Non-Exempt
Summary
Paragraph here of the summary of the job
Minimum Qualifications
1. Must possess a current license to practice professional nursing in the Commonwealth of Pennsylvania.
2. Certification by the American Association of Nurse Anesthetists (AANA).
3. Graduate of an accredited school of nurse anesthesia.
Preferred Qualifications
1. Previous experience in a Charge or supervisory position.
Essential Functions
1. Exemplifies St. Clair Hospital’s Customer Service Behavioral Expectations in all interactions. Treats customers with respect, compassion, and hospitality; anticipates, identifies, and responds to individual needs; makes a positive first impression by acknowledging customers; and demonstrates flexibility while maintaining priorities.
2. Under the supervision of the manager, prepares and maintains the CRNA work schedule assuring adequate staffing levels to cover all areas of the anesthesia service.
Title
Cost Center
FLSA
Summary
Minimum Qualifications
Preferred Qualifications
Essential Functions
RN
4356
Non-Exempt
Paragraph here of the summary of the job
Must possess a current license to practice professional nursing in the Commonwealth of Pennsylvania
Previous experience in a Charge or supervisory position.
Exemplifies St. Clair Hospital’s Customer Service Behavioral Expectations in all interactions. Treats customers with respect, compassion, and hospitality; anticipates, identifies, and responds to individual needs; makes a positive first impression by acknowledging customers; and demonstrates flexibility while maintaining priorities.
Certification by the American Association of Nurse Anesthetists (AANA).
Under the supervision of the manager, prepares and maintains the CRNA work schedule assuring adequate staffing levels to cover all areas of the anesthesia service.
Graduate of an accredited school of nurse anesthesia.
I have attached a copy of a job description, where most of the 400 job descriptions have the same format. Is this even possible, especially with the bullets for essential functions and minimum qualifications? We are converting to an online system and it'll be much easier to upload into the system from excel. Any help would be REALLY appreciated!
I also would like for the macro to see that there are 400 job descriptions within a folder and do it automatically without having to open up all 400 job descriptions.
Thank you so much in advance!