Results 1 to 3 of 3

Thread: Macro to copy data from multiple workbooks and sheets

  1. #1
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    13

    Macro to copy data from multiple workbooks and sheets

    I have several workbooks that I need to copy data from row 9 onwards excluding text containing the word "total" in Col A and values to the right of the word total in the the destination workbook from row9 onwards. All the worksheets must be copied to the relevant worksheet in the destination workbook. The row containing the word total and the text bwelow that must be left intact

    I have attached a sample source workbook "tax -br1" as well as the destination workbook "consolidated Tax.2012

    Your assistance in this regard is most appreciated

    See Cross post below

    http://windowssecrets.com/forums/sho...874#post877874
    Attached Files Attached Files
    Last edited by Howardc; 11-07-2012 at 11:22 PM.

  2. #2
    Member Rajan_Verma's Avatar
    Join Date
    Sep 2011
    Posts
    81
    Rep Power
    14
    You can visit here to have a code to accomplish this task

    Split Data into Multiple Workbook « excelpoweruser

    Thanks
    Rajan verma

  3. #3
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    13
    Thanks for the reply and the link-will test the code & let you know

Similar Threads

  1. Replies: 2
    Last Post: 05-28-2013, 05:32 PM
  2. Replies: 3
    Last Post: 05-14-2013, 03:25 PM
  3. Replies: 7
    Last Post: 05-08-2013, 07:12 PM
  4. Macro to copy data in specific Columns
    By Howardc in forum Excel Help
    Replies: 0
    Last Post: 04-19-2013, 10:42 AM
  5. Macro To Clear Certain Data Across Many Sheets
    By Howardc in forum Excel Help
    Replies: 2
    Last Post: 12-04-2012, 09:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •