Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for an ID number in a column
Hello,
I have created a worksheet that consists of 550 people. I would like to configure a box where I put the person ID # in and the page moves to that person. Is there a way for me to do this? An also a macro that will take me back to the top of the page in one quick move? I have all the ID number in column A:5 down to A:18154. I am still in the learning process but have made some major advancement in Excel. Any information would be appreciated. -- Thank You Glenn |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for an ID number in a column
Why not use Excel? EditFind will go to the ID# for you. To get back to the
top of the spreadsheet, use Ctrl-Home. Regards, Fred Glenn" wrote in message ... Hello, I have created a worksheet that consists of 550 people. I would like to configure a box where I put the person ID # in and the page moves to that person. Is there a way for me to do this? An also a macro that will take me back to the top of the page in one quick move? I have all the ID number in column A:5 down to A:18154. I am still in the learning process but have made some major advancement in Excel. Any information would be appreciated. -- Thank You Glenn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inverse of the column function? i.e. input a number, output thecorresponding column text label | Excel Worksheet Functions | |||
How do I turn excel columns from column number to column letter? | Setting up and Configuration of Excel | |||
Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
Display missing Part Number if Column A does not match column B | Excel Worksheet Functions | |||
Auto number w/ different letter-number combos in same column | Excel Worksheet Functions |