I have a workbook I'm working on in Excel 2007. Sheet 1 has a list of students, location, dates attended, test score and so on. I want a function that will search column A (which is the location) and put each students info (the whole row) onto a different sheet. Each location will be on a different sheet, with all students and all there info on that sheet.
A B C D E
Location Date Start Date End Score Name
Washington Jan 1 Jan 10 92% John Doe
Florida Jan 15 Jan 25 100% Jane Doe
Florida Jan 15 Jan 25 96% Jim Doe
Texas Feb 1 Feb 10 92% Joe Doe
As I add more entries into sheet 1, I want it to autofill the same info to another sheet.
All Students from Washington on Sheet 2
All Students from Florida on Sheet 3
All Students from Texas on Sheet 4
There could be potential errors as lets say there are two John Doe in Washington, So what row to update. Why would you want to move the data to other sheets. You can filter on locations to see it. That would be the first way. Other way would be to have a macro when it ran, could move data to sheets