Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Merger Two Data Sheet | Excel Discussion (Misc queries) | |||
Transfer data from sheet to sheet | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions |