I need a formula / macro to look for a name in workbook 1 in 10 different columns in workbook 2. if the name is in any of the columns, then i want to copy and paste a group of cells from associated with that column in workbook 2 and put them into exact same cell arrangement in workbook 1. confusing explanation i know. i'm sorry. i'm not a veteran programmer but am constantly working to understand more. any help would be appreciated.