Transfer data

Jojo537 Posts 1 Registration date Friday August 11, 2017 Status Member Last seen August 11, 2017 - Updated on Aug 11, 2017 at 04:37 PM
I have an excel spread sheet that has columns for last name, first name, office locations, and date. I may have 10 items listed in the column location for Boston and 15 for Los Angeles. Is there a way that when I type in all the information in Sheet 1, then any location that has Boston as a location is automatically entered also in Sheet 2 and the data for Los Angeles is automatically entered in Sheet 3?. I am using Excel 2010.