Results 1 to 9 of 9

Selecting specific data on a worksheet and moving it to a table on another worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    04-30-2012
    Location
    Virginia, USA
    MS-Off Ver
    Excel 2007
    Posts
    10

    Selecting specific data on a worksheet and moving it to a table on another worksheet

    After days of trying to solve this on my own with no luck, I need some help.

    I have 2 worksheets, B and C.

    Worksheet B includes 3 columns. Column A has an item name, Column B has a bin number, and Column C and a quantity number.

    Worksheet C has a table with the y axis being the Item and the x axis being the bin number. I need to select the item names on Worksheet B that have a quantity number greater than 0 and then place the item name with the applicable quantity number in the table on Worksheet C under the applicable Bin number.

    I figured out how to move the item name using the "If" statement, but I would like to make it in to a loop statement since these quantities are updated daily and the number of item names can change.

    Please see my attached Excel sheet.

    Thank you for any help. I've been struggling.
    Attached Files Attached Files

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