Macro that lookups in one sheet then updates inventory with specific text and date sold

Hello,

Rather new to VBA code so I am still learning. However one of my projects seems rather simple, but is giving me trouble.

In the "Working Sheet" I want to be able to input an item# which then is a simple vlookup to populate the other information. However when you press "Button 1" I want the following to happen:

1) In the sheet "Inventory" I want "Status" to be updated to "SOLD" and "Date Sold" to populate with today's date.

I've been playing with some VBA code I found here trying to modify it to no avail, but I know this is possible. Can anyone help me out?

There could be many items listed there, but I dont expect more than 10-15 items max. And inventory doesn't carry a quantity in column D as each item is unique and no item repeats, there is no two of the same thing. Think of this like a goodwill type market.

Awesome! Thanks that helps so much!

I am trying to do a replace where price in "d:20 - d:30" in "Working Sheet" is able to replace the price listed in "Inventory" in column "H"

Please Login or Register  to view this content.