+ Reply to Thread
Results 1 to 5 of 5

Code for moving rows of data automatically from one worksheet to another not working

  1. 10-23-2014, 06:16 AM #1
    Kashyap_17 is offline
    Registered User
    Join Date
    10-21-2014
    Location
    Bangalore, India
    MS-Off Ver
    Professional Plus 2010
    Posts
    3

    Question Code for moving rows of data automatically from one worksheet to another not working

    I'm using the following code for moving row from sheet named Backlog to sheet named Billing, when the column J value becomes BILLED for a row. But it does not work if the range is converted to table (the row moves beyond the table rather than becoming a part of it):

    Please Login or Register  to view this content.
    Help will be much appreciated
    Last edited by Fotis1991; 10-23-2014 at 06:23 AM. Reason: Pls use code tags around your codes as per forum rules.
    Reply With QuoteRegister To Reply
  2. 10-23-2014, 08:06 AM #2
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Code for moving rows of data automatically from one worksheet to another not working

    Hi,
    Welcome to this forum...
    Try this ..
    Please Login or Register  to view this content.
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com
    Excel is not a matter of Experience, its a matter of Application.
    Say Thanks, Click * Add Reputation
    Reply With QuoteRegister To Reply
  3. 10-24-2014, 12:44 AM #3
    Kashyap_17 is offline
    Registered User
    Join Date
    10-21-2014
    Location
    Bangalore, India
    MS-Off Ver
    Professional Plus 2010
    Posts
    3

    Re: Code for moving rows of data automatically from one worksheet to another not working

    Hi,

    Thanks for the prompt reply! But the code is not working, the row is moving to Backlog itself and not to Billing (that to below the table, it is not becoming part of the table).
    Reply With QuoteRegister To Reply
  4. 10-24-2014, 04:07 AM #4
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Code for moving rows of data automatically from one worksheet to another not working

    What is meant by making part of the table.. ?
    I didn't get that..

    What I meant is you want to move the row to the billing sheet at the last of the table..
    Am I correct....? if not, then pls clarify..

    Regards,
    Reply With QuoteRegister To Reply
  5. 10-27-2014, 08:17 AM #5
    Kashyap_17 is offline
    Registered User
    Join Date
    10-21-2014
    Location
    Bangalore, India
    MS-Off Ver
    Professional Plus 2010
    Posts
    3

    Re: Code for moving rows of data automatically from one worksheet to another not working

    By part of table I mean the moved row should become a row of the table, that is the formatting, data validation etc of the table it has moved to is applied (this I want because I want to link the table in billing sheet to a pivot table).

    Also, the modified code is not moving row to billing at all, it is just moving within booking.

    Thanks
    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. Moving rows of data automatically
    By jamesplant1977 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-15-2013, 11:32 AM
  2. Automatically moving rows to another worksheet which contain certain data
    By whiterosejo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2012, 08:29 PM
  3. Excel 2007 : Moving data date on several rows automatically
    By hilltopper in forum Excel General
    Replies: 0
    Last Post: 09-29-2011, 01:56 PM
  4. Assistance required for Automatically moving data to another worksheet
    By j.vaughan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2008, 07:40 AM
  5. Moving data automatically from one worksheet to another
    By ltlbt in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 06-24-2008, 11:19 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1