Results 1 to 5 of 5

Transfer to Sheets Macro..Need Help

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-15-2013
    Location
    United States
    MS-Off Ver
    Excel 2016
    Posts
    214

    Transfer to Sheets Macro..Need Help

    Hello Everybody i have the following macro that searches a column and then transfers that row to the correct sheet and place it in the first available row. Right now it separates into the correct sheets and finds the first available row. The problem I have is that i already have a format set up on each individual page and I'm just trying to get the first 6 columns A-F to copy from the one sheet to the correct sheet without wiping out the format I already have setup on the other pages. Any help will be greatly appreciated.

    Sub TransferToSheets()
    Dim sh As Worksheet, lr As Long, rng As Range
    lr = Sheets(1).Cells(Rows.Count, 6).End(xlUp).Row
    Set rng = Sheets(1).Range("F2:F" & lr)
        For Each c In rng
            If c <> "" Then
                Set sh = Sheets(c.Value)
                c.EntireRow.Copy sh.Cells(Rows.Count, 1).End(xlUp)(2)
            End If
        Next
    End Sub
    Last edited by trevor2524; 08-20-2013 at 02:21 PM.

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. Macro to transfer row of data between sheets based on certain criteria.
    By kmc86 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-26-2012, 10:40 AM
  3. Replies: 1
    Last Post: 03-15-2012, 02:24 PM
  4. Macro to transfer data from main sheet to sub sheets
    By sandbach in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-02-2010, 05:42 PM
  5. Macro to transfer data between sheets...
    By ChrisMattock in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-20-2007, 10:35 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1