I'm trying to find out if something is possible, and stumped as to where to actually begin. I have 2 sheets (Exception Points and Exception Tracking 2012). The Exception Points sheet has a master list of Employees, and tabs/sheets for each employee. The Tracking file is the 'master' copy for all Exceptions.
What I want to be able to do, if possible, is, have the Exception Points file pull data for each employee. Basically, a way to say if, for example row 5 contains Sally Smith, copy some cells from that row. Basically, I would need to go through all the rows of data, and for each line that has the specific employee listed, copy a couple cells from that row to the other sheet. Is this able to be done, without getting too crazy?
Bookmarks