Copy filtered data and paste values
Solved/Closed
Related:
- Copy filtered data and paste values
- Pasting values in filtered cells ✓ - Forum - Excel
- Formula to copy and paste values in excel automatically - Guide
- Excel vba copy paste values next empty row - Guide
- Excel data validation multiple values - Guide
- Macro to copy and paste values ✓ - Forum - Excel
1 reply
rizvisa1
Apr 7, 2010 at 09:43 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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