Freezing old data in excel

**sapphire** · 05-26-2008, 03:39 PM

Is there a way to copy a column from a table that updates dynamically and paste it in another column and freeze the copied data afterwards?

In other words, I want to copy today's data into another column then freeze the data in today's column. By freeze, I mean I just want the value to be displayed in today's column, not the formula.

**sapphire** · 05-26-2008, 03:40 PM

Is there a way to copy a column from a table that updates dynamically and paste it in another column and freeze the copied data afterwards?

In other words, I want to copy today's data into another column then freeze the data in today's column. By freeze, I mean I just want the value to be displayed in today's column, not the formula.

**VBA Noob** · 05-26-2008, 03:51 PM

Your duplicate posts have beung merged.

Please read forum rules below before posting again.

As for your issue take a look at paste special

http://www.bettersolutions.com/excel...I216522111.htm

VBA Noob

**sapphire** · 05-26-2008, 04:03 PM

Hi, Sorry I didn't know how to delete the post. I posted twice by mistake.

**sapphire** · 05-26-2008, 05:23 PM

Paste special isn't useful for me in this case because I want the column I copied the contents from to freeze, not the column in which I pasted the contents. So the original column should only have values, not formulas. Is this possible?