Not being able to copy-paste in new worksheet

[walrasianxl]

Hi,

I'm trying to paste onto a new worksheet a column which i copied from another worksheet. The values in the column are as a result of a formula i used. But when i copy and paste it into the new worksheet, all i get is a column of zeros. I just need that one column.

The reason i believe is that in the new worksheet i don't have the cell values which were used in the original worksheet. How do i solve this problem?

Many thanks.

[Royy]

Hi!

Copy the Column and go to your desired work sheet, Select the desired Column where you want to paste the entries. Right click on the highligted cells and click on Paste Special. A dialogue box will appear, Select "Values" in the paste options and click OK.

[walrasianxl]

Thanks a bunch Royy! It worked!

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.