+ Reply to Thread
Results 1 to 2 of 2

Transfer Rows to Other Sheets using a loop

  1. 10-17-2013, 06:40 PM #1
    trevor2524
    trevor2524 is offline
    Forum Contributor
    Join Date
    06-15-2013
    Location
    United States
    MS-Off Ver
    Excel 2016
    Posts
    214

    Transfer Rows to Other Sheets using a loop

    Hello Everybody, So i'm been trying for hours and trying random things and still cant get this so I decided to post what I have working online and seeing if anybody can help me wit the rest. The last things I need is for the rows to be cut and pasted to the correct Sheet according to Column I on sheet 1. Then the empty row on sheet one will be deleted and after that it will rerun the Autofill 2 macro and all other rows will be moved up until there are no more values found in Column A. Help is needed. TestProject.xlsm
    Last edited by trevor2524; 10-17-2013 at 07:10 PM.
    Reply With QuoteRegister To Reply
  2. 10-18-2013, 04:31 AM #2
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Transfer Rows to Other Sheets using a loop

    The naming in the title column is not consistent. Newspaper - NY is Newspaper while FL -TV is TV, but not FL. You will get sheet names which appears to be the same, but they are not and as result some of the rows will go in to different sheet.
    Attached Files Attached Files
    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 to Transfer data from multiple sheets into rows on a master sheet
    By serrone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-30-2013, 06:35 AM
  2. [SOLVED] Transfer Rows with specific color from Multiple Sheets onto one sheet
    By bukejr in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-19-2012, 09:49 AM
  3. Macro to transfer data to different sheets and different rows
    By inventory in forum Excel General
    Replies: 1
    Last Post: 03-15-2012, 02:24 PM
  4. conditional transfer of rows to other sheets based on cell content of 2 colums
    By ashncg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2011, 12:22 PM
  5. Using a formula to transfer information between sheets, in different rows
    By SKAL in forum Excel General
    Replies: 4
    Last Post: 02-19-2009, 06:59 PM

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