![]() |
#2
|
|||
|
|||
![]() Code:
Option Explicit Sub CopyOwnTab() Application.ScreenUpdating = False Dim i As Long Dim Lastrow As Long On Error GoTo M Lastrow = Sheets("Master").Cells(Rows.Count, "A").End(xlUp).Row Dim ans As String For i = 2 To Lastrow ans = Sheets("Master").Cells(i, 1).Value Sheets("Master").Rows(i).Copy Sheets(ans).Rows(Sheets(ans).Cells(Rows.Count, "A").End(xlUp).Row + 1) Next Application.ScreenUpdating = True Exit Sub M: MsgBox "No such sheet as " & ans & " exist" Application.ScreenUpdating = True End Sub |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy data as well as formatting from one workbook to another. | LearnerExcel | Excel | 1 | 03-10-2018 01:35 PM |
Copy excel data | wjmj | Word | 1 | 12-18-2015 10:10 PM |
a macro that can copy data from copy.xls to our current excel macro.xls based on criteria: | udhaya | Excel Programming | 1 | 11-12-2015 10:12 AM |
Copy Like Data | MBragg | Excel | 3 | 10-13-2015 11:45 PM |
Copy data from one form to another | jodjamz | Outlook | 0 | 04-28-2015 05:07 PM |