is it possible to paste only those cells with formulars from a selected range?

Posted by DAn on June 28, 2001 6:53 AM

I have to sheets in similar structure , each has its own raw data and some dynamic cells formulated by them.
I want to copy the formulars only, but don't want to bother selection the cells one by one, is it possible
to select the whole sheet and copy only those with formulars? It does not work when using the normal paste special feature of fomulars, because it will change my cells without formulars also.

any trick to play on this?

Posted by Brian P on June 28, 2001 11:53 AM

Not Sure But..

Dan,
You might want to check out this link. You can select an area, use goto special select formulas,numbers and run the following program. The one problem you might have is you need to know where the first formula should go.
Good Luck
Brian P

http://www.j-walk.com/ss/excel/tips/tip36.htm