DKRbella0814
Board Regular
- Joined
- Aug 10, 2008
- Messages
- 155
I have a workbook which contains two spreadsheets:
sheet1 = JobCompetencies
sheet2 = JobDescriptionForm
On sheet 1, there are a number of job titles listed in A2:A8; some examples of job titles include: (A2) Administration, (A3) CFO, (A4) Customer Service. Columns B-D are designated for specific authorities. Columns E-G are designated for specific job responsibilities and Columns H-J are designated for certain job competencies.
Whenever a specific authority, responsibility, or competency apply to a certain job title, a "X" is marked in the intersecting cell.
So, for example:
A2= Administration has X's in cells: B2, F2, I2
A3= CFO has X's in cells: C2, E2, H2
A4 = Customer Service has X's in cells: B2, J2
Sheet 2 is designed to be a standard form which contains the following basic information: Job Title (B2) , Authority (A5:A10), Responsibilities (A15:A20), Competencies (A30:A35)
What I would like to know is this: considering that each job title will have different job titles, authorities, responsibilities, and competencies which are applicable,
Would it be possible to write a macro or short code to take the active row's information (Job title and all applicable job authorities, responsibilities, and competencies) and copy/paste the appropriate information into sheet2 (the jobdescriptionform) in appropriate areas of the form?
sheet1 = JobCompetencies
sheet2 = JobDescriptionForm
On sheet 1, there are a number of job titles listed in A2:A8; some examples of job titles include: (A2) Administration, (A3) CFO, (A4) Customer Service. Columns B-D are designated for specific authorities. Columns E-G are designated for specific job responsibilities and Columns H-J are designated for certain job competencies.
Whenever a specific authority, responsibility, or competency apply to a certain job title, a "X" is marked in the intersecting cell.
So, for example:
A2= Administration has X's in cells: B2, F2, I2
A3= CFO has X's in cells: C2, E2, H2
A4 = Customer Service has X's in cells: B2, J2
Sheet 2 is designed to be a standard form which contains the following basic information: Job Title (B2) , Authority (A5:A10), Responsibilities (A15:A20), Competencies (A30:A35)
What I would like to know is this: considering that each job title will have different job titles, authorities, responsibilities, and competencies which are applicable,
Would it be possible to write a macro or short code to take the active row's information (Job title and all applicable job authorities, responsibilities, and competencies) and copy/paste the appropriate information into sheet2 (the jobdescriptionform) in appropriate areas of the form?