+ Reply to Thread
Results 1 to 4 of 4

Copy Values from Sheet1 to Sheet2 only if column I has a "X" in the line

  1. #1
    Forum Contributor
    Join Date
    11-08-2012
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2010
    Posts
    110

    Copy Values from Sheet1 to Sheet2 only if column I has a "X" in the line

    Hi Experts,

    I am trying to copy values from Get Data tab to F-28 tab but only for the rows that I place an "X" in column I on Get Data tab. I have attached the file I am working on. I would like to have a button to click which does the copy and paste. On the F-28 tab I would like for there to be no blanks in the copy paste, i.e., If copying lines 2, 4, 6 from Get Data then paste into 2, 3, 4 on F-28 tab. I need the paste to start on line 2 on F-28 tab. Thank you very much in advance for any help.
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    6,025

    Re: Copy Values from Sheet1 to Sheet2 only if column I has a "X" in the line

    Click the button I've added to the "Get Data" sheet in the attached, et voila!

    Keep in mind this is VERY basic code I've written. It does what you want, but it's got no bells and whistles.

    As with most things in Excel, this is ONE way of doing it. There are no doubt many many others.

    Should get you going though.

    Hope it helps.

    BSB
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Copy Values from Sheet1 to Sheet2 only if column I has a "X" in the line

    Maybe:

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    12-05-2015
    Location
    Akron, OH
    MS-Off Ver
    15.0
    Posts
    424

    Re: Copy Values from Sheet1 to Sheet2 only if column I has a "X" in the line

    Hmmm... I may be late to the party, but here is what I came up with -- not sure why mine is so much longer.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. copy sheet 2 data as it is in sheet3 if column "B" matches in sheet1 & Sheet2
    By shloksurya in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2015, 09:35 PM
  2. Replies: 5
    Last Post: 04-16-2015, 03:20 PM
  3. [SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2013, 08:28 PM
  4. Auomatically populating "Sheet2" when "Sheet1" is full
    By longbow007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2013, 11:50 AM
  5. Replies: 0
    Last Post: 10-09-2012, 08:46 PM
  6. Copy column from sheet2 if specific cell in sheet1 is "QLD"
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-09-2012, 04:57 PM
  7. [SOLVED] comparing data in column [sheet1] with data in column [sheet2] and execute "yes" or "no"
    By dragon_m0nsta in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-14-2012, 03:27 AM

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