I'm new to Mr Excel. Using Excel 2007: The cells on sheet A-report are populated from cells on sheet B-data. How do I filter the data on sheet B so only data for those records populate on sheet A. Example:Sheet B = A1-header A2-tom A3-dan A4-tom then columns B,C,D have more data pertaining to that person. If I add a combo box with the names, how can I make the data only related to that person ie:tom, show all his data from both of his records?
Last edited: