Previous Topic Next Topic

Copy rows from 1 sheet, to multiple sheets

Closed
RFarley - Apr 28, 2010 at 05:47 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 28, 2010 at 10:35 AM
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.

Example:
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


Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 28, 2010 at 10:35 AM
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
0