+ Reply to Thread
Results 1 to 8 of 8

Copy data from specific cells and columns not adjacent from sheet to another

  1. #1
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Copy data from specific cells and columns not adjacent from sheet to another

    hi,
    i would transfer data not contiguous cells (i1,i2) & columns b,c,e,g,j from sheet to another
    Attached Files Attached Files
    Last edited by ABDELFATTA; 06-10-2020 at 03:12 PM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,422

    Re: Copy data from specific cells and columns not adjacent from sheet to another

    It might help us better understand what you want if the result was illustrated using some sample data on the Copy and Purchase sheets.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,709

    Re: Copy data from specific cells and columns not adjacent from sheet to another

    Hi ABDELFATTA,

    Try the below code ... Your file is simple & I highly encourage you to remove the merge cells if you plan to use macros as much as you could as they'll just create more problems

    Please Login or Register  to view this content.
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

  4. #4
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: Copy data from specific cells and columns not adjacent from sheet to another

    hi, nankw it repeats data more than time when run the macro i tested by fill one row it repeats the data and give me error run time 1004 and highlight this line
    HTML Code: 

  5. #5
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: Copy data from specific cells and columns not adjacent from sheet to another

    hi, jetemc i edited my file and put the expected result in sheet(copy)

  6. #6
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,709

    Re: Copy data from specific cells and columns not adjacent from sheet to another

    I have revised the code … I have only tested it with multiple rows the first time

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: Copy data from specific cells and columns not adjacent from sheet to another

    great work , thanks so much

  8. #8
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,709

    Re: Copy data from specific cells and columns not adjacent from sheet to another

    Glad to help & thanks for the reps

+ 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. Replies: 5
    Last Post: 04-25-2019, 11:10 AM
  2. [SOLVED] Copy data from Specific Cells on one Sheet to Specific Cells on Another Sheet
    By catnam in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-17-2018, 04:01 PM
  3. [SOLVED] copy data in specific columns to another sheet
    By steve400243 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2017, 10:05 AM
  4. copy data from multiple sheet to master sheet with specific columns only
    By sinha.riteshabap in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2013, 06:59 AM
  5. Replies: 7
    Last Post: 12-04-2012, 06:23 AM
  6. [SOLVED] Seach for data from one sheet to another sheet and copy past adjacent columns
    By mahtabshaikh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-19-2012, 10:19 AM
  7. Search to find matching cells and copy/transpose adjacent data to original sheet?
    By thump4r in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-12-2009, 09:20 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