View Single Post
  #1   Report Post  
_Bigred
 
Posts: n/a
Default hiding all data in a sheet except desired

Hello All,

I have a worksheet that has approx 20 different categories (columns) and
then 5609 rows (1 for each employee).

Is there a way for me to setup another sheet (while hiding the original or
similiar) then on 2nd sheet have a lookup field by Employee Last Name &
First Name - and if it finds a row that matches will display the desired
information on this 2nd sheet?

I realize that access would be better suited for this, but given time and
the amount of records that isn't feasible for me currently.

TIA,
_Bigred