+ Reply to Thread
Results 1 to 5 of 5

Copy 2 Columns of Data from Sheet1 and Paste in Sheet2

  1. #1
    Registered User
    Join Date
    04-08-2016
    Location
    California
    MS-Off Ver
    windows 7
    Posts
    28

    Copy 2 Columns of Data from Sheet1 and Paste in Sheet2

    Hi,

    I am a novice in VBA and still learning and would appreciate any help I can get.

    Issue: I need to write a macro that will copy two columns of data if a condition is met. The condition is "Tall" in column 2 in Sheet1. If "Tall" exist in Column2 then copy Column 4("Name") and paste it in Column 16("Name") on Sheet2. Then copy column 14 ("Amt") and paste it on column 22("Amt") on Sheet2.

    Then I want to keep doing this until I have copied columns 24-29("Amt") into Sheet2 Column22.

    I have tried to write a macro but have had no success. I have written the macro to copy two different Amt columns but no success.When I run the macro nothing happens. Not even a message error appears. I have attached my workbook.

    Please let me know if you have any questions.

    Thanks!
    Attached Files Attached Files
    laryhaty

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    15,239

    Re: Copy 2 Columns of Data from Sheet1 and Paste in Sheet2

    Try
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-08-2016
    Location
    California
    MS-Off Ver
    windows 7
    Posts
    28

    Re: Copy 2 Columns of Data from Sheet1 and Paste in Sheet2

    Is there anyway to add the text in cell N1(Column14) in Sheet1 to the Column20 (T) in Sheet2 rows 2-3. So for instance, lets say the text in cell N1 in Sheet1 was "Oranges Fee". Then in Column 20 (T) in Sheet2, Rows 2-3 have Orange Fees. So for each column name in Sheet 1 have that name in Column20. I have attached the workbook again to show you what I am looking for!
    Thanks so much
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    15,239

    Re: Copy 2 Columns of Data from Sheet1 and Paste in Sheet2

    Change to
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-08-2016
    Location
    California
    MS-Off Ver
    windows 7
    Posts
    28

    Re: Copy 2 Columns of Data from Sheet1 and Paste in Sheet2

    Great, thanks!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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