Results 1 to 12 of 12

How to copy a row from one sheet to another if the number a column D1 greater than 0

Threaded View

  1. #1
    Registered User
    Join Date
    05-30-2012
    Location
    Cumbria England
    MS-Off Ver
    Excel 2010
    Posts
    8

    How to copy a row from one sheet to another if the number a column D1 greater than 0

    Hello,

    I am looking for a little help.

    I am building a stock system for our stores that needs to be in excel.
    I am getting quite far a head now but i need help on this on.

    The is a worksheet for every staff member (up to 40) within each sheet are 30 odd rows of kit when they sign out some kit column D will be populated with how much of this kit they are borrowing. If they still have kit outstanding there will be a number in column D with the amount they have. I would like to copy this row to sheet ("Kit Outstanding") until the kit is returned.

    File attached of what i have done so far.

    Thanks Gordon
    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