Copy rows from 1 sheet, to multiple sheets [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
763
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!