+ Reply to Thread
Results 1 to 5 of 5

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

  1. #1
    Registered User
    Join Date
    12-04-2018
    Location
    Chicago
    MS-Off Ver
    2010
    Posts
    28

    Question 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?
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Macro that lookups in one sheet then updates inventory with specific text and date sol

    When you press the button will you only have 1 item listed in the quantity column or could you have many?

    And I know you haven't mentioned this but as a matter of what would seem a normal business requirement, why doesn't your inventpry sheet carry a quantity. Column D could be markes as Sold but what if you have an inventory of 10 and you sell 1 why would you want to mark the item as out of stoke and Sold?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    12-04-2018
    Location
    Chicago
    MS-Off Ver
    2010
    Posts
    28

    Re: Macro that lookups in one sheet then updates inventory with specific text and date sol

    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.

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macro that lookups in one sheet then updates inventory with specific text and date sol

    Maybe:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  5. #5
    Registered User
    Join Date
    12-04-2018
    Location
    Chicago
    MS-Off Ver
    2010
    Posts
    28

    Re: Macro that lookups in one sheet then updates inventory with specific text and date sol

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Extract rows to another sheet based on specific words + auto updates
    By scooter2012 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-13-2022, 09:17 PM
  2. [SOLVED] Live inventory to block out sold out styles or sizes.??
    By isalmon in forum Excel General
    Replies: 8
    Last Post: 09-26-2018, 02:22 PM
  3. [SOLVED] I need help calculating Cost of Goods Sold in Multi Sku Inventory Tracking Model Please!!
    By trickyricky in forum Excel Programming / VBA / Macros
    Replies: 35
    Last Post: 05-14-2018, 04:18 PM
  4. [SOLVED] Extracting specific date from Inventory list
    By amymy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-14-2017, 03:28 AM
  5. [SOLVED] Macro to copy date to specific sheet based on data from another sheet.
    By RichTea88 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-09-2013, 11:28 AM
  6. [SOLVED] Need remaining average inventory price after partial inventory is sold
    By Akano in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2012, 04:12 AM
  7. Calculationg number of items sold after a specific date
    By JohnFletcher66 in forum Excel General
    Replies: 3
    Last Post: 10-28-2011, 07:39 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1