This is ugly, I'll try to keep it short as possible.
I am currently running a worksheet that contains around 500 lines of data
relating to customers sites.
I also have a form within the workbook that uses a vlookup function to
populate fields once the site code is entered. This is used to present the
data on a single page arranged like a data base rather than having to read
along horizontal lines.
What I would like to acheive is a method of navigating to the site row in
the worksheet from within the form presented data.
For example, once a site code is entered, the data fields are populated and
presented to the user,If data editing is needed I would like to be able to
activate a macro designed to navigate to the correct row within the worksheet
where the data is actually stored (as opposed to the form that presents the
data)
Any help would be appreciated.