Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
merge data
I have a worksheet with two columns: job titles and job codes.
I have 15 other worksheets that have several columns including job code, and I need to add the job title in a column next to the job code. Example of 1st workbook: Job Title Job Code President A4000 Secretary B1200 Technical Asst D3211 etc. Other 15 workbooks are set up like: Job Code Score Average Total A4000 421 321 732 D3211 320 170 642 I just need to add a column that shows Job Title next to Job Code in the 15 workbooks, pulling that data from first workbook. Help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge data in two worksheets based on key data value (like databas | Excel Worksheet Functions | |||
data merge | Excel Discussion (Misc queries) | |||
Can I merge data in 2 sheets matching rows of data by last name? | Excel Discussion (Misc queries) | |||
mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) |