Excel data base
 

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.

Excel data base
 

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" wrote in
message ...
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.

Excel data base
 

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

"Tyro" wrote:

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" wrote in
message ...
This is ugly, I'll try to keep it short as possible.
I am currently running a worksheet that contains around 500 Rows 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 rows
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.

Excel data base
 

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


"Malcolm McMaster" wrote in
message ...
My apologies, The rows contain data unique to each site. columns
categorise
the data.

"Tyro" wrote:

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" wrote in
message ...
This is ugly, I'll try to keep it short as possible.
I am currently running a worksheet that contains around 500 Rows 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 rows
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.