I have two data sources and I'm dumping one source onto sheet1 and the other
onto sheet2. I have a common id that is unique in each sheet in column B in
each sheet). Sheet1 has all my active and correct id's. Sheet2 has ALL id's
wheather they are active or not and also has a value in column BC) I need to
fill onto sheet1 somewhere beside the active id. How do I get the value from
sheet2 over to sheet1?