Hello

Below is a cut from my TransformData macro (I'm switching a user-friendly table into a pivot-table friendly list

'Copy the data for planned to column
Sheets("Inventory").Selec
Range(ThisCol & "2:" & ThisCol & FinalRow).Copy
Destination:=Sheets("PivotlistaTarget").Range("G" & NextRow
Sheets("Pivotlista").Selec

The problem is that this returns the formulas, I would like it to return only the values. (It is a very big list and it is very time consuming to add $-signs in the entire Inventory-list)