+ Reply to Thread
Results 1 to 15 of 15

Copy Sheet1 few column data to sheet 2 selected column

  1. #1
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2013/ Microsoft windows 10 pro (10.0.14393 Build 14393)
    Posts
    137

    Copy Sheet1 few column data to sheet 2 selected column

    Dear Expert,
    i want to copy sheet1 few column to sheet2 and sheet1 column copy range start from row 6 & will paste to sheet 2 selected column from blank row, like as sheet1 A column data will copy from A6 to all & paste will sheet2 column H & paste row will be start from blank (if any data already avail) .

    column will copy/paste from sheet1 to sheet2 as below:
    Sheet1 A=Sheet2 C, Sheet1 D=Sheet2 B, Sheet1 E=Sheet2 A, Sheet1 B=Sheet2 G.

    Please help me in this regard.


    Best Regards
    Wahid

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    5,997

    Re: Copy Sheet1 few column data to sheet 2 selected column

    With Sheet1 as the active sheet, try:
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    8,059

    Re: Copy Sheet1 few column data to sheet 2 selected column

    If data in sheet1 columns have same row length...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere.....
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember......Mark Thread as Solved.
    Excel Forum Rocks!!!

  4. #4
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2013/ Microsoft windows 10 pro (10.0.14393 Build 14393)
    Posts
    137

    Re: Copy Sheet1 few column data to sheet 2 selected column

    Thanks, your code is ok & working but need a small correction that data pasting always start from sheet2 column "A" blank row and other column data paste also start from this row considering A blank row. other column any cell can blank but data should paste from A column blank row.

    Please help in this regard.

    Best Regards
    Wahid

  5. #5
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2013/ Microsoft windows 10 pro (10.0.14393 Build 14393)
    Posts
    137

    Re: Copy Sheet1 few column data to sheet 2 selected column

    Your first code is suitable for me & add my 2nd requirement with this code.

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    8,059

    Re: Copy Sheet1 few column data to sheet 2 selected column

    in post 3 change 7 to 1

  7. #7
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2013/ Microsoft windows 10 pro (10.0.14393 Build 14393)
    Posts
    137

    Re: Copy Sheet1 few column data to sheet 2 selected column

    then its show me "Object required", please attend this.

  8. #8
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2013/ Microsoft windows 10 pro (10.0.14393 Build 14393)
    Posts
    137

    Re: Copy Sheet1 few column data to sheet 2 selected column

    Dear Expert,
    Post 2 code mostly solve my problem, you just add post 4 requirement on post 2 code.

    Thanks

  9. #9
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    8,059

    Re: Copy Sheet1 few column data to sheet 2 selected column

    Upload a sample file of your actual setup...and expected result...

  10. #10
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    5,997

    Re: Copy Sheet1 few column data to sheet 2 selected column

    I don't quite understand what you mean by the following:
    data pasting always start from sheet2 column "A" blank row and other column data paste also start from this row considering A blank row. other column any cell can blank but data should paste from A column blank row.
    Please explain in detail what you want to do referring to specific cell addresses, rows, columns and sheets.

  11. #11
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2013/ Microsoft windows 10 pro (10.0.14393 Build 14393)
    Posts
    137

    Re: Copy Sheet1 few column data to sheet 2 selected column

    Dear Expert,
    I attached my document there i want to copy sheet1 to sheet2 belo column and always copy from A6 row for all column sheet1 and always paste from sheet2 a column blank row for all column.


    sheet1 column=sheet2 column as below:
    A=A
    B=B
    C=C
    D=D
    I=E
    M=F
    R=G

    if sheet 2 A column has already data up to row 10 then my paste will start from A11 row and all data all column will paste from row no 11. that means paste row start depend on sheet2 a column blank row.

    Thanks
    Wahid
    Attached Files Attached Files

  12. #12
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    5,997

    Re: Copy Sheet1 few column data to sheet 2 selected column

    Try:
    Please Login or Register  to view this content.

  13. #13
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    8,059

    Re: Copy Sheet1 few column data to sheet 2 selected column

    Please Login or Register  to view this content.

  14. #14
    Forum Contributor
    Join Date
    07-27-2017
    Location
    Dhaka
    MS-Off Ver
    MS Excel 2013/ Microsoft windows 10 pro (10.0.14393 Build 14393)
    Posts
    137

    Re: Copy Sheet1 few column data to sheet 2 selected column

    Dear Expert,
    My problem is solved.

    Thanks

  15. #15
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    8,059

    Re: Copy Sheet1 few column data to sheet 2 selected column

    Glad you got it sorted..Tx for rep +

+ 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: 3
    Last Post: 07-25-2019, 05:02 PM
  2. Replies: 1
    Last Post: 06-01-2018, 11:33 AM
  3. Filter range and copy selected column visible data and paste other sheet
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-19-2017, 11:37 AM
  4. Copy data from sheet1 column with dynamic date, and copy data to second sheet column
    By Renaliiii in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-25-2016, 04:44 PM
  5. [SOLVED] copy data from sheet1 to sheet2 based on column (A) sheet1 and column (C) sheet2
    By AWITCHER in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-13-2014, 03:20 PM
  6. Macro to copy row with same num (sheet1) and sum its column in another sheet
    By patua in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-21-2014, 03:02 AM
  7. Copy certain data from Sheet1 to Sheet 2 based on values in a column on Sheet1
    By theglitch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2013, 01:28 PM

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