Hi
I dont have experience of VBA but have a code which moves a row of data from a worksheet called Report to a worksheet called Archived based on column Q = Yes. I want the code to paste the value into worksheet Archived as a value so that it removes any formulas from the data. How can I amend...