Solved How to keep formula in the original cell that gets inserted

February 16, 2016 at 19:09:40
Specs: Windows 7
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


See More: How to keep formula in the original cell that gets inserted

Report •


#1
February 17, 2016 at 05:43:56
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.


Report •

#2
February 18, 2016 at 06:54:21
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


Report •

#3
February 18, 2016 at 08:28:44
✔ Best Answer
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.


Report •

Related Solutions


Ask Question