Copy/Paste selected value only into new excel

Hi all, I am having issue with copying a selected rows / columns from one excel to another , the column I am copying has formula in it but I only want the value of it. I am having trouble copying specific columns, read and write activity don’t work for formulated cells if you only want the value.

Thanks

Hi pema,

Please take a look at these posts, there are some examples: