+ Reply to Thread
Results 1 to 10 of 10

Copy data of column b according to column a

  1. 10-05-2020, 01:19 PM #1
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Copy data of column b according to column a

    hi,
    i have data in Range A4:A6 and B4:B23

    now i want to data copy B7:B23 and paste to A7

    if
    i have data in Range A4:A10 and B4:B23

    now i want to data copy B11:B23 and paste to A11

    copy data according to range A4:?


    hope some one will help
    Attached Files Attached Files
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *
    Reply With QuoteRegister To Reply
  2. 10-05-2020, 01:25 PM #2
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,746

    Re: Copy data of column b according to column a

    How about 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 10-05-2020, 01:33 PM #3
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Re: Copy data of column b according to column a

    Quote Originally Posted by Fluff13 View Post
    How about 
    Please Login or Register  to view this content.
    Thank you sir
    Reply With QuoteRegister To Reply
  4. 10-05-2020, 01:36 PM #4
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,746

    Re: Copy data of column b according to column a

    You're welcome & thanks for the feedback.
    Reply With QuoteRegister To Reply
  5. 10-05-2020, 01:39 PM #5
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Re: Copy data of column b according to column a

    Sir
    this code not working with table range
    please any solution
    Reply With QuoteRegister To Reply
  6. 10-05-2020, 01:44 PM #6
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,746

    Re: Copy data of column b according to column a

    How about 
    Please Login or Register  to view this content.
    This will not work if you have non-contiguous blanks in col A
    Reply With QuoteRegister To Reply
  7. 10-06-2020, 12:03 PM #7
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Re: Copy data of column b according to column a

    Quote Originally Posted by Fluff13 View Post
    How about 
    Please Login or Register  to view this content.
    This will not work if you have non-contiguous blanks in col A
    Thanks for the reply
    But i am not able to work this code on to table

    Please help
    Reply With QuoteRegister To Reply
  8. 10-06-2020, 12:04 PM #8
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,746

    Re: Copy data of column b according to column a

    Then please supply a realistic sample workbook.
    Reply With QuoteRegister To Reply
  9. 10-06-2020, 02:22 PM #9
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Re: Copy data of column b according to column a

    Working very well now
    thanks for your valueable time
    Reply With QuoteRegister To Reply
  10. 10-06-2020, 02:26 PM #10
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,746

    Re: Copy data of column b according to column a

    You're welcome & thanks for the feedback.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data validation: copy the total figure from column B into the correct analysis column
    By CJW01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-22-2019, 06:38 PM
  2. 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
  3. Copy Column, Transpose Values into a row, clear column data-repeat copy in to next row
    By bbis21 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-17-2014, 02:40 PM
  4. Copy data from column K to column B if Column C and column I match
    By goog2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2013, 12:19 PM
  5. Macro to copy and paste special values for column data and filter column data
    By ascottbag in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-10-2012, 02:15 PM
  6. Forumla for Moving/Copy Data from Single Column (Rows) to Multiple Column
    By thchughesmathews in forum Excel General
    Replies: 5
    Last Post: 02-07-2012, 04:55 PM
  7. Merge two workbooks. Copy column data based on numerical ID match of another column.
    By giallofever in forum Excel General
    Replies: 2
    Last Post: 03-16-2009, 12:26 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1