Transfer data

[Closed]
Report
Posts
1
Registration date
Friday August 11, 2017
Status
Member
Last seen
August 11, 2017
-
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.