Copy only formulas from a field of celles, do not copy data

[Chrigu]

Hello,
From a sheet containing numbers and formulas, i wish to copy in another sheet, but ONLY the formulas, not the data (numbers).
Thanks
Chrigu

[Special-K]

Not sure you can do that with a formula, probably need VBA.
I may be wrong, lets see who replies...

[Chrigu]

Regards and thanks!
Trying to be clear :
How to copy only formulas from a field of cells in an excel sheet in folder A to another sheet in another excel folder B, without copying anything else (no numbers, no formats no conditional formats, only formulas and only formulas, leaving other cells blank (no zeroes: blank)?
Thanks

[Special-K]

I think I've understood this correctly.
You've written this in the formulas section so Im assuming you want some form of formula answer.
Presumably you have something like this

A1 contains the value 2
A2 contains the value 3
A3 contains the formula =A1+A2.

You just want the formula in A3 copied across to another sheet, though this will probably change the result of that formula and possibly produce errors if the cells don't contain data.

As stated I doubt this is possible via a formula, you probably have to use VBA to identify which cells have formulas and which have values.

UPDATE: Check these out, I havent looked that closely.

Via a UDF
https://www.ozgrid.com/VBA/ExcelIsFormula.htm

Via Condtional Formatting
https://groups.google.com/forum/#!to...sc/a_Mj0s-Fns0
https://www.mrexcel.com/archive/date...ke-this-exist/