When I Right Click, Insert, Move cells right the cell that is getting inserted has an = (cell address, J2 for instance) that it takes along the formula to L2 . That doesn't create any problem but I now have to re-enter that formula = J2 again to to cell K2. Once isn't bad but for the entire worksheet is. I tried the if statement in J2 with IF(I2>0;I2;;k2) and get err 504 .

There is a file at

Be aware that the formula shown in I32 is missing the - but the formula in I2 should read G2-H2

SEE SAMPLE http://www120.zippyshare.com/v/YyRp...Still trying,

BC

message edited by Basecalc

re: I tried the if statement in J2 with IF(I2>0;I2;;k2) and get err 504 .You have an extra semicolon in your formula. Perhaps that is causing the error.

re:

... I now have to re-enter that formula = J2 again to to cell K2. Once isn't bad but for the entire worksheet is.I don't use Open Office, but in Excel you can "AutoFill" a formula to the bottom of a range by double clicking to AutoFill handle.

In other words, when you insert a new Column L, your existing Column L formulas will move to Column K. If you then enter a formula in the "new" L2, and then double click the AutoFill handle in the lower right corner of L2, Excel will copy that formula down to the bottom of the range adjacent to that cell (Column K).

For other methods of AutoFilling cells in Excel, see here:

https://support.office.com/en-us/ar...

I assume Open Office has similar AutoFill methods.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

The answer to Auto Filling is yes though it defeats the purpose of "AUTO" to my original question.

I've given plenty of thought and am getting closer to the result I'm trying to acheive and will ask a new question that if that answer works I'll post a result back here for others to refer as a work around.

Thanks,

BC"Sometimes Complicity Creates Simplicity"

message edited by Basecalc

If you really want this to be "AUTO" you should consider using Macros. Some information on OO Calc macros can be found here, DAGS for more.

http://www.openoffice.org/documenta...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think Microsoft's new Surface Go will be a hit?

Discuss in The Lounge

Poll History