Results 1 to 4 of 4

Search Sheet2 Column A For Value In Textbox On Sheet1 Then Offset Right By 1-5 Column

Threaded View

sweetrevelation Search Sheet2 Column A For... 11-07-2009, 06:43 PM
mrice Re: Search Sheet2 Column A... 11-08-2009, 07:35 AM
sweetrevelation Re: Search Sheet2 Column A... 11-08-2009, 01:31 PM
protonLeah Re: Search Sheet2 Column A... 11-08-2009, 01:32 PM
  1. #1
    Registered User
    Join Date
    04-21-2009
    Location
    Puyallup, WA
    MS-Off Ver
    Excel 2010
    Posts
    55

    Search Sheet2 Column A For Value In Textbox On Sheet1 Then Offset Right By 1-5 Column

    Having trouble with a a macro. I have a search function that works just fine. It pulls information from Sheet2 and places the data (which will always be integers) in 5 cells on Sheet1.

    My problem is this: I have added buttons to the right (of the cells that hold the data on Sheet1) which needs to increment or decrement the left-most respective values up or down by one... which I can do but the hard part for me is...

    I then need to search in column A to find the value in the textbox/searchbox field and when found, I need to offset to the right (columns B, C, D, E, or F depending on the "Service n"). When offset and the cell is found, I need to update this value with the newly updated value created by clicking the up or down button (basically adding or subtracting 1 from this cell).

    Essentially, this is used to update a product SKU quantity. When one SKU is sold, I have the "Down" button there to update the inventory amount so I enter the SKU, Press Search, then find the service I want to decrement, press the "Down" button to the right when a SKU is sold, and it would decrement that SKU quantity on Sheet2 by 1 for that particular service.

    I hope I've explained it thoroughly. I'll send $5 to the first person's Paypal that can figure this out. I'm sure it's simple and I'm overlooking something. I told my girlfriend I could figure this out but I need some help fellas (and ladies)!


    If you have a minute, please have a peek at my attached Excel document for a clear idea of what I mean.
    Attached Files Attached Files
    Last edited by sweetrevelation; 11-07-2009 at 06:55 PM.

Thread Information

Users Browsing this Thread

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

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