Copy filtered data and paste values
Solved/Closed
Related:
- Copy filtered data and paste values
- Tmobile data check - Guide
- Mint mobile data not working ✓ - Network Forum
- How to copy paste youtube link on android - Guide
- How to reset safe folder password without losing data ✓ - Android Forum
- Based on the values in cells b77 b88 ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
7 Apr 2010 à 21:43
7 Apr 2010 à 21:43
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
7 Apr 2010 à 23:11