“Insert row” modifies some cells i don’t want to
I have this sheet I’m trying to register any kind of payment I receive.
I used a macro to auto-insert few data, but in the macro I have a “Shift cells down” command, so in the right side where there is every client in “Unique” formula, just drops down 1 row number.
How do I prevent F column to modify the number row when adding new Row in ABCDE.
I have this sheet I’m trying to register any kind of payment I receive.I used a macro to auto-insert few data, but in the macro I have a “Shift cells down” command, so in the right side where there is every client in “Unique” formula, just drops down 1 row number.How do I prevent F column to modify the number row when adding new Row in ABCDE. Read More
