+ Reply to Thread
Results 1 to 8 of 8

macro to copy data range from sheet and past to specific other sheets

  1. #1
    Forum Contributor
    Join Date
    11-17-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    355

    macro to copy data range from sheet and past to specific other sheets

    Hi,

    I have a data in sheet "List". Data range is from Cell A1 to till the last cell in row 1 which contains data and from A1 to till end of the last cell in column A which contains data.

    Need code to copy the whole data range and past only on those sheets which sheet name are matching with names exist in 1st row of sheet "names".

    for e.g data to pasted only in sheets "Aditya_Birla", "Apollo_Munich", "ICICI_Lombard", "Bajaj_Allianz", "Bharti_Axa" and "Reliance_Capital". Because only these name are exist in first row of "Names". Ignore all other sheets
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-12-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    775

    Re: macro to copy data range from sheet and past to specific other sheets

    Hi saravanan

    maybe you could use something like this?

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    11-17-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    355

    Re: macro to copy data range from sheet and past to specific other sheets

    above code is coping only Column A.

    Entire data range is not copies.

  4. #4
    Forum Contributor
    Join Date
    10-12-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    775

    Re: macro to copy data range from sheet and past to specific other sheets

    Quote Originally Posted by saravanan1981 View Post
    above code is coping only Column A.

    Entire data range is not copies.
    there is only data in Col A in the "List" sheet. Do you mean all columns and rows with data in the "List" sheet?

  5. #5
    Forum Contributor
    Join Date
    11-17-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    355

    Re: macro to copy data range from sheet and past to specific other sheets

    yes. entire data range.

  6. #6
    Forum Contributor
    Join Date
    10-12-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    775

    Re: macro to copy data range from sheet and past to specific other sheets

    what will be the last column in the sheet?

  7. #7
    Forum Contributor
    Join Date
    02-13-2014
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    140

    Re: macro to copy data range from sheet and past to specific other sheets

    need to find last non blank cell in 1st row. copy till that. here last column is W.

  8. #8
    Forum Contributor
    Join Date
    10-12-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    775

    Re: macro to copy data range from sheet and past to specific other sheets

    in that case, define the last row and column:

    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. Replies: 11
    Last Post: 10-19-2016, 10:47 PM
  2. [SOLVED] Macro needed to copy data from master sheet to a number of specific sheets
    By krish2503 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-25-2015, 04:42 PM
  3. Replies: 0
    Last Post: 07-24-2014, 09:11 AM
  4. [SOLVED] Macro for COPY and PAST RANGE of data to ANOTHER workbook
    By Atoms in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2012, 02:45 AM
  5. Replies: 0
    Last Post: 11-19-2009, 09:20 AM
  6. Excel Macro Copy&Past data between 2 sheets
    By Nett in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-13-2009, 09:15 AM
  7. macro to copy specific data from one sheet and paste into two sheets
    By Shogun in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-26-2009, 04:56 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