+ Reply to Thread
Results 1 to 2 of 2

How to copy one entire row from one excel file to another excel sheet

  1. 02-07-2013, 01:44 AM #1
    jsrakesh4u
    jsrakesh4u is offline
    Registered User
    Join Date
    02-05-2013
    Location
    Chennai
    MS-Off Ver
    Excel 2007
    Posts
    25

    Smile How to copy one entire row from one excel file to another excel sheet

    Hello forum

    I need to transfer certain rows from one excel to another excel sheet, such that rows belong to one date should be sent to respective sheet. It means all rows having date Jan_1st will be trasferred to Sheet named Jan_1st and all rows having Feb_6th will be transferred to sheet named Feb_6th and so on.

    Please refer this I am done upto this. http://www.excelforum.com/excel-prog...her-sheet.html

    Now, I want to transfer rows having particular date to the respective newly created sheet.
    Could you please help me in creating macro for this.

    Anything helps. Thanks in advance.

    PS: Modifying the above mentioned thread http://goo.gl/K5j0z according to this scenario is greatly appreciated.
    Reply With QuoteRegister To Reply
  2. 02-07-2013, 04:16 AM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: How to copy one entire row from one excel file to another excel sheet

    'SHEET1 TO MANY SHEETS
    Here's a macro for parsing rows of data from one sheet to many sheets named for the same values in a specific column.
    It not only can parse the rows, it can create the sheets if they are missing. There is a sample sheet there where you can test this out.
    Last edited by JBeaucaire; 12-27-2019 at 10:26 PM.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    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)

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1