| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Selection using Vlookup
I have a spreadsheet with 20K rows. I need to select the employee ID and the
respective rows of data from the spreadsheet and put it into another worksheet. Example, the employee is C123456 and I want all the rows of data where his ID is referencend in a particular column. I tried vlookup, match, index but have had no luck with these. This is a process we'll be running monthly which basically tracks no of tickets an employee handles in that period. Any suggestions are appreciated. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data selection.. | Excel Discussion (Misc queries) | |||
| Dynamic Data Series Selection from Data Validation Dropdown? | Charts and Charting in Excel | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
| VLOOKUP or dropdown in the cell depending on selection in another | Excel Discussion (Misc queries) | |||
| Problem with Vlookup array selection | Excel Worksheet Functions | |||
Threaded Mode
