Reply to thread

Message: [QUOTE="LP, post: 3217044"] Hello, I have a workbook with 2 tabs. The Data tab has transactional detail with one column being the name of the person who made the transaction. The other tab is a report tab. I need to have the transactional detail auto show on this tab based on a drop down menu of names (people who made the transaction). It's exactly like using auto filter but without the hidden lines that autofilter has. Can this be done and how? The reason why I'm not using auto filter is because the data tab has too much calculation and it takes forever for it to refresh. Thanks LP [/QUOTE]