+ Reply to Thread
Results 1 to 5 of 5

Macro for copying rows based on empty cell

  1. 07-23-2013, 06:56 PM #1
    rajkumarmp
    rajkumarmp is offline
    Registered User
    Join Date
    03-06-2012
    Location
    chennai
    MS-Off Ver
    Excel 2003
    Posts
    34

    Macro for copying rows based on empty cell

    Hi CHAMPS,

    I have a input file which has ID's missing for some specific dates.

    I need a macro to arrange all the missed ID's with corresponding dates (as mentioned in OUTPUT)

    I have mentioned clearly in the attached file as INPUT and OUTPUT. Please help. Thanks in Advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-23-2013, 07:13 PM #2
    rajkumarmp
    rajkumarmp is offline
    Registered User
    Join Date
    03-06-2012
    Location
    chennai
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Macro for copying rows based on empty cell

    Please help me on this............
    Reply With QuoteRegister To Reply
  3. 07-24-2013, 03:58 AM #3
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Macro for copying rows based on empty cell

    Output is in new sheet.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 07-24-2013, 08:59 AM #4
    rajkumarmp
    rajkumarmp is offline
    Registered User
    Join Date
    03-06-2012
    Location
    chennai
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Macro for copying rows based on empty cell

    Thanks. Its working great...
    Reply With QuoteRegister To Reply
  5. 07-24-2013, 10:04 AM #5
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Macro for copying rows based on empty cell

    http://www.excelforum.com/excel-prog...mpty-rows.html
    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. Macro code for copying formulas till the last non-empty cell
    By Zozika in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-28-2013, 08:47 AM
  2. MACRO to empty a range of cells based on whether specified cell is empty
    By TBJV in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2013, 10:35 PM
  3. Using a macro to copying data from 1 sheet, and pasting into next empty cell
    By Varial in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-13-2012, 04:05 PM
  4. Need help Visual Basic Copying Rows until Empty Cell
    By nkf531 in forum Excel General
    Replies: 1
    Last Post: 01-04-2012, 02:59 AM
  5. Macro to delete duplicate rows based on empty cells
    By 100d in forum Excel General
    Replies: 2
    Last Post: 08-24-2011, 05:42 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