Results 1 to 1 of 1

Copy row to another sheet on condition

Threaded View

  1. 09-02-2011, 08:14 AM #1
    ksr
    ksr is offline
    Registered User
    Join Date
    07-29-2011
    Location
    ireland
    MS-Off Ver
    Excel 2003
    Posts
    1

    Thumbs up Copy row to another sheet on condition

    Hi

    I am from a different field altogether, but somehow I've my developed interest in MS Excel.
    I've attached a file. My query is, how to I setup a macro or code to copy the entire row (row only, not the formulae) to other sheet based on a condition that a particular cell in the row has value(not empty) .(In this case, from sheet Jan- H6=13 so I need to copy the range C6:G6 to sheet Feb C4:G4 and C7:G7 to C5:G5 and so on.Thanks....
    Attached Files Attached Files
    Last edited by ksr; 09-02-2011 at 08:16 AM. Reason: To add a file
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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