Results 1 to 12 of 12

Move cell based on IF statement

Threaded View

  1. #1
    Registered User
    Join Date
    04-10-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    7

    Move cell based on IF statement

    I want to move data from one cell to another based where the value in column B is >0. The values in column B are formula driven from a different sheet and attached to the relevant account number which will constantly be changing, as a number is entered into the enter value sheet it will populate against the relevant cell in totals sheet.

    The problem I have is that when a new value is entered previous data will disappear as the formula criteria isnt met. I want to capture the >0 value as it appears and move it so I can total it elsewhere. I apologise if this is garbled I am very new to VBA. Can anyone help please? I have attached my spreadsheet for clarity. Thanks!
    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