Results 1 to 11 of 11

simple if statement

Threaded View

  1. #1
    Registered User
    Join Date
    12-02-2014
    Location
    toronto
    MS-Off Ver
    2013
    Posts
    11

    simple if statement

    Hi all,

    I need some help. I need a quick VBA scripted IF statement (macro) that compares 2 cells within the same row (in this SAMPLE cells A and B) in sheet 1.

    If the cells are equal then the ENTIRE row needs to be copied and pasted onto sheet 2.
    If they are not equal then the ENTIRE row needs to be copied TWICE onto sheet 2 and this needs to loop until it has gone through all lines.

    Sample attached. thanks in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Simple VBA If Statement help
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2013, 09:37 AM
  2. [SOLVED] Help with simple IF statement
    By timohteee in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-22-2013, 10:57 PM
  3. simple:IF statement
    By Rick-O-Shay in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 12-31-2009, 01:44 AM
  4. simple If-then statement
    By eonizuka in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-22-2009, 07:37 PM
  5. simple for you if statement fix
    By britt.govols in forum Excel General
    Replies: 1
    Last Post: 09-07-2006, 02:52 PM

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