Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I have created a worksheet that has 18000 + rows. There are 550 ID numbers for my employees. What I would like to do is create a cell that when I type in a ID# it will take me to the persons ID# in column "A" where ever it is located. In cell number 53 or cell number 17200. just to give you a little heads up each employee has 30 rows of information so there's a gap between ID#'s. I can use Go To but other people will be using this and they are not a computer knowledgeable. I need to make this as user friendly as possible. Basically I need to create a macro or formula that will bring you down to a ID# in a single column. "Sample" Search box |__2__| A 1 2 3 4 - - Thank you for all your help! Glenn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
compare data in column A with column B to find duplicates | Excel Discussion (Misc queries) | |||
find last row value in column when using MATCH to find column | Excel Worksheet Functions | |||
Find something in column a then find if column B matches criteria | Excel Discussion (Misc queries) | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
To find Multiple values in column B for a unique value in column A | Excel Worksheet Functions |