Excel data base

[Malcolm McMaster]

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.

 

[Tyro]

I don't quite understand your terms. Excel has no lines. It has rows and
columns. Perhaps if you could explain in Excel terminology, I could help.

Tyro

 

[Malcolm McMaster]

My apologies, The rows contain data unique to each site. columns categorise
the data.

 

[mvk]

Hi! Goto www.tejniya.com, click on Documents at the top and then excel, the
file you want is called "Form edit" (I have included the 2007 and 2003
files). The solution basically uses the Match function to locate the row,
and then the macro takes the user to the correct row.

thxs.

Manish