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