ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Looking for an ID number in a column (https://www.excelbanter.com/excel-worksheet-functions/227290-looking-id-number-column.html)

glenn

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

Fred Smith[_5_]

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





All times are GMT +1. The time now is 05:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com