I have a master data sheet that one column in the sheet that represents a sub set of the data. When I add information to the master sheet, I want the information to populate the sheet that represents the sub set. The master sheet contains 495 rows of info broken down into 15 columns. Rather than filter thru the data, It would be easier to just look at the other sheet will full data pertaining only to that smaller group.
Can this be done?