+ Reply to Thread
Results 1 to 1 of 1

Inventory mgmt: macro to find compare 2 value on 2 different sheets

  1. #1
    Registered User
    Join Date
    11-05-2007
    Posts
    1

    Inventory mgmt: macro to find compare 2 value on 2 different sheets

    Hi, newbie in VBA here so would appreciate any help.

    Essentially this is a simple inventory management sheet in which i want to check if i have sufficient quantity of a particular product in inventory to sell to a customer.

    I need help with a macro to find in "Inventory" sheet, B17, in "Data" sheet Column B from row 11 onwards and if a match is found, compare the number in "Inventory" sheet, D17, with "Data" sheet, in column D but in the row in which the first match was identified.

    If the "Inventory" sheet, D17, is more than the corresponding "Data" sheet cell in column D, then a MsgBox appears.

    If the "Inventory" sheet, D17, is equal to or less than the corresponding "Data" sheet cell in column D, then a different MsgBox appears.

    If the the first match can't be found in row 11, then it would move on to the next row and so on.

    Sorry for the long question and messy upload.

    Many thanks in advance!
    Attached Files Attached Files
    Last edited by ginkgo; 11-05-2007 at 02:18 AM. Reason: Forgot to upload

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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