Hi
I have a formula that runs in column K of a sheet that pulls a value from a pivot table. This is compared to a value that will be entered in column A.
The data in the pivot table that column K pulls from changes regularly but I want to be able to enter a value into column A and when entered turn the result of the column in column K from a formula to a value so that when the data in the pivot table changes, the data entered and the value compared to remains as a permanent record.
Can anybody help with this?
I have a formula that runs in column K of a sheet that pulls a value from a pivot table. This is compared to a value that will be entered in column A.
The data in the pivot table that column K pulls from changes regularly but I want to be able to enter a value into column A and when entered turn the result of the column in column K from a formula to a value so that when the data in the pivot table changes, the data entered and the value compared to remains as a permanent record.
Can anybody help with this?
