Night mode
You need to log in to create posts and topics.

Calling a Macro within a cell

Hello,

I'm attempting to automate a macro within an “IF” and “AND” statement, so as not having to “click” on the macro to execute it after each data entry. I've attached two spreadsheets to illustrate. One works fine, and with the second one I'm attempting to create a formula in Column J so there is no need to “click” on the macro when I enter a number in Column J. When a number is entered in Column I, the macro deletes the value in Column D and moves all values 1 column to the left.

Please help.

I didn't find the right solution from the Internet.

References:-
https://forum.openoffice.org/en/forum/viewtopic.php?f=20&t=91537
Promotional Marketing Videos

Thanks

Night mode