I am moving rows from one sheet to another based on a criteria in a cell value. If the cell value is met, it moves to another sheet. However when it moves, I need it to move as values. One of my cells has a formula in it and I just want the value of that cell in the new sheet. Below is part of my code where it moves the row. My question is where do I add in the PasteSpecial or the equivalent code to move it as values? Thanks!
For Each xCell In xRg
If CStr(xCell.Value) = "Pipeline" Then
xCell.EntireRow.Copy Destination:=Worksheets("Pipeline2").Range("A" & B + 1)
xCell.EntireRow.Delete
B = B + 1
If you just want the values, you can just set the ranges equal to eachother.
Edit: To keep formatting also,