Global formula

G

George

How can I apply a formula to a range of cells without entering into each
cell. I have a spreadsheet with values and want to convert to another
currency value.
 
G

Gary Fuller

George,
Can you use the EUROCONVERT function in an adjacent cell then autofill the
rest of the way? I wonder if you can build a macro that looks at each cell
and as long as the value is >0 have the macro insert the conversion formula
then stop doing so as soon as it sees a zero value. I look forward to someone
posting that knows how.
Gary
 
Top