Auto show data but without using Auto Filter

[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

 

[Gord Dibben]

Could be that a Data Validation dropdown and VLOOKUP formula(s) may be in
order.

Visit Debra Dalgleish's site for info on VLOOKUP function to pull data based
on value, in your case, names. Note the downloadable sample
workbooks.

http://www.contextures.on.ca/xlFunctions02.html

Also see Debra's site for creating Data Validation dropdown menus for
choosing a name from a list.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP