Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conjugating 2 sheets. pleae help i'm already late for the deadline
i have two spreadsheets in the same workbook (yr2005 and yr2007), each with
the columns a: department B: job title C: over D: current E: to date. one is for year 2005 and the other is for year 2007. some of the the departments and positions have changed (some depts and or job titles no longer exist and some are new) but most of them are the same. but i need all to be in this spreadsheet without any doubles. WHAT I NEED IS: a macro that, takes the info on those 2 spreadsheet, conjugates, and makes one, all inclusive spreadsheet with the columns a: department B: job title C: over05 D: current05 E: to date05 F: over07 G: current07 H: to date 07. having only one row per each departments job title E.G. if its in both (yr2005 and yr 2007) spreadsheets all columns would have the corresponsing values. if its a new position (didnt appear in yr2005) columns c d and e would be blank. if its an old position (in yr 2005 but not in 2007) columns f g and h would be blank. -- thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deadline Reminder | Excel Programming | |||
SET UP AUTOFILL! Pleae HELP!! | Excel Worksheet Functions | |||
Deadline Notice | Excel Worksheet Functions | |||
Late Binding or Late Anything | Excel Programming | |||
Active Deadline | Excel Discussion (Misc queries) |