Hi all,

I'm a newbie, so please be gentle :)

Here's my project.
I've got a sales spreadsheet that I've got one user form that adds
initial data
(item#, qty, make, model, cost) to consecutive rows. I have given them
constant Item
numbers in column A # 1-120. This part works great. I'm trying to get a
new
user form to go back & add actual cost & shipping into new columns
based on
what item number the user types into a text box in the same user form
as the
additional data.

IE: I have items 1 - 5 & want to add actual cost & shipping to item 3.
The user
would pop up the form from a button with a macro & the fields would ask
for
item#, actual cost & actual shipping. The user inputs this info & it
finds the
correct item & adds the new info.

I'm sure this is pretty basic, but I don't know how to make it find the
correct
item# .

Can anyone help?

Thanks!!!


--
Soundman
------------------------------------------------------------------------
Soundman's Profile: http://www.excelforum.com/member.php...o&userid=24428
View this thread: http://www.excelforum.com/showthread...hreadid=380316