Hello all,

WARNING!!!! Noob programmer!!!! Having said that, I can program a bit but im new to vba. What I am trying to do is make a macro that:

1. looks in column A (list of names) of spreadsheet 1
2. compares it to the columns in spreadsheet two. Each column represents a specific text item the name could be categorized under.
3. posts the column header from spreadsheet 2 into column k of spreadsheet 1.

So if Bob (from sheet 1 column a) is in accounting (accounting is the header and matched in sheet 2 column b), I want the macro to take the Accounting header and paste that text in column K of sheet 1.

Ive poked around for about a week now trying to cookbook my own with pieces of code, but alas ive grown frustrated. I hope someone out there can help me!!!!