Results 1 to 3 of 3

if a 1 appears in any of three specific columns, then cut row and move to next sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-29-2011
    Location
    Scotland
    MS-Off Ver
    Excel 2003
    Posts
    122

    if a 1 appears in any of three specific columns, then cut row and move to next sheet

    In attached workbook there are 0 and 1's in columns G, H and I.
    Any ideas on:
    • If a 1 appears in any of these three columns (G, H and I) on Sheet2, then move the row that the 1 (or 1's) are in, from Sheet2 to Sheet3. Would need to determine how many rows are in Sheet3 before pasting in new rows (to avoid overwriting rows that are already in there).
    Attached Files Attached Files
    Last edited by intothewild; 11-25-2012 at 05:21 PM.

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