Programming Question

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?
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
If you use Excel Jeanie to post a small, but representative, sample of your data, your input and your desired result, it would help us give good advice on your problem.
 
Upvote 0
So, for example if

A3= CFO and the authorities that applied were (Approve Quote Package (B3), Approve Budget (C3) ; marked by "x"'s; the responsibility that applied was (Manage Accounting Dept (F3) marked by "x"; and the competency that applied was prior management experience (H3) marked by "x"

A4= Customer Service Rep and the authority that applied was (Approve Purchase Orders (D4) marked by "x"; the responsibility that applied was service customer requests (G4) marked by "x"; and the competency that applied was conflict resolution (I4) marked by "x"

Then could I write a code to select all cells marked by an "x" to copy and paste into the 'Form' spreadsheet, such that all authorities marked by an "x" on the active row are pasted into 'Form' cells A5:A10, all responsibilities marked by an "x" on the active row of the first spreadsheet be pasted to 'Form' cells A15:A20, and all competencies of the active row marked by an "x" be pasted to 'Form' A30:A35?
 
Upvote 0
So, for example if

A3= CFO and the authorities that applied were (Approve Quote Package (B3), Approve Budget (C3) ; marked by "x"'s; the responsibility that applied was (Manage Accounting Dept (F3) marked by "x"; and the competency that applied was prior management experience (H3) marked by "x"

A4= Customer Service Rep and the authority that applied was (Approve Purchase Orders (D4) marked by "x"; the responsibility that applied was service customer requests (G4) marked by "x"; and the competency that applied was conflict resolution (I4) marked by "x"

Then could I write a code to select all cells marked by an "x" to copy and paste into the 'Form' spreadsheet, such that all authorities marked by an "x" on the active row are pasted into 'Form' cells A5:A10, all responsibilities marked by an "x" on the active row of the first spreadsheet be pasted to 'Form' cells A15:A20, and all competencies of the active row marked by an "x" be pasted to 'Form' A30:A35?
 
Upvote 0

Forum statistics

Threads
1,224,524
Messages
6,179,308
Members
452,904
Latest member
CodeMasterX

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top