![]() |
|
#1
|
|||
|
|||
![]()
Possibly...
Code:
Sub Not_Tested() Dim rg As Range Dim rC As Range Dim a As Integer 'Change the names of the worksheets to match 'Change "Some Specific Value" to ??? With Worksheets(1) Set rC = Intersect(.Columns("C"), .UsedRange) End With For Each rg In rC If rg.Value = "Some Specific Value" Then For a = 1 To 3 rg.EntireRow.Copy Worksheets(2).Cells(1048576, 1).End(xlUp).Offset(1) Next a Else rg.EntireRow.Copy Worksheets(3).Cells(1048576, 1).End(xlUp).Offset(1) End If Next rg End Sub |
![]() |
Tags |
copy/paste rows |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
cloudforgiven | Excel Programming | 6 | 01-05-2017 07:30 PM |
Trying to find a macro that will copy a cell and paste that value to a specific sheet | bryans88 | Excel Programming | 1 | 12-23-2015 01:40 PM |
copy checkbox string and paste it in excel sheet | MOHAMMEDSALMAN | Excel Programming | 7 | 10-29-2015 03:50 AM |
Want to change Macro to copy and paste data to new sheet | Vortex69 | Excel Programming | 0 | 12-23-2014 09:53 PM |
copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |