This problem pertains to Excel.I hope I'm able to explain this well enough. I work for a not for profit in their special events department. I have an excel document with 5 pages (2013,2012,2011,2010,2009), each page contains about 1200 names with various information about each person. It might be noteworthy that all of the pages have the exact same organization across all pages, so A1 will always be first name and A3 will always be Total $ raised etc etc. I will be adding 4 columns to my 2013 sheet that say Total $ raised in 2012 then 2011 etc etc. I'm looking for a way to tell excel this.For the 2012 columnIf (first name) and (Last name) match in page 2012 then insert the value in cell (total $ raised)this would be the same for other pages.
My problem is making excel look at the entire workbook for the name match and not just the same cell that the name is XXXXX XXXXX
I'm sorry Joshua, because of HIPAA regulations I can't upload the file to you. What I can do is make up a dummy file and upload that though that will take a little time.