Auto show data but without using Auto Filter

L

LP

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top