Copy filtered data and paste values
Solved/Closed
        Related:         
- Copy filtered data and paste values
 - Tmobile data check - Guide
 - Based on the values of cell b77 ✓ - Excel Forum
 - How to reset safe folder password without losing data ✓ - Android Forum
 - How to copy paste youtube link on android - Guide
 - Data transmission cable - Guide
 
1 response
                
        
                    rizvisa1
    
        
                    Posts
            
                
            4478
                
                            Registration date
            Thursday January 28, 2010
                            Status
            Contributor
                            Last seen
            May  5, 2022
            
            
                    766
    
    
                    
Apr 7, 2010 at 09:43 PM
    Apr 7, 2010 at 09:43 PM
                        
                    see if this helps
Change this line
Rows(i).Copy Destination:=Worksheets("Itemized Costs").Cells(NewRow, 1)
to
Sheets("Itemized Costs").Range(NewRow & ":" & NewRow) = Range(i & ":" & i).Value
            Change this line
Rows(i).Copy Destination:=Worksheets("Itemized Costs").Cells(NewRow, 1)
to
Sheets("Itemized Costs").Range(NewRow & ":" & NewRow) = Range(i & ":" & i).Value
        
    
    
    
    
Apr 7, 2010 at 11:11 PM