I dont know how to subject this

[~Alan]

XL2000

In worksheet_change eventis a list "A"Part#, "B"QTY,
"C"Description,"D"MANUFACTURER, "E"Price,"F"UNITS
There is a userform that I use to update this list.
I also have a form that has vlookup that looks up the Part#, from column
"DR" and gets the rest of this information from
(sheet"parts") "B"QTY, "C"Description,"D"MANUFACTURER,
"E"Price,"F"UNITS
The way the part number gets to column DR is by selecting a cell in
(sheet"parts""A")
most of the time if I know the part # i will just enter it into
("sheet1"DR" -1) and then everthing is looked up.

Problem when the part QTY or the PRICE changes i have to go to
(sheet"parts") and look up the part number
and make the changes:

Question Is there an easier way to do this?
I thought, if I was to select the part number in ("sheet1"DR" -1)
that maybe it would take me to
that part number in (sheet"parts").

 

[Mark E. Philpot]

Personally, I do not like lookups. A userform with
listboxes to show your info and buttons to suit your needs
is my preference. I can write one for you. See some of my
handiwork at: http://au.geocities.com/excelmarksway.

Send dummy (not real data) sheets to:
(e-mail address removed)

I have done this before!
reagards
Mark E. Philpot