"Insert row" modifies some cells i don't want to

[gabrielesava90]

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.

[#2]

@gabrielesava90  

I see you've had nearly 75 views without a reply. I don't know for sure why that is, but suspect it could be that people are puzzled by how you're approaching this capturing of new data.

It would appear that you are inserting a new row (or new rows) at the top of the history. In general, especially if this is an input sheet holding the history of payments and expenses, it would make more sense to track transactions by adding new ones to the bottom of the table storing that data. You can always have a separate output sheet where that order is displayed in reverse order if that is for some reason important. A transactional history is best created with new rows, new transactions, entered at the bottom. 

You'd also help us help you--this image shows that you've rendered any real names anonymous--by posting a copy of the actual workbook rather than just ;an image. If you aren't able to do that by attaching the workbook to one of your postings here, put the workbook on OneDrive or GoogleDrive and paste a link here that grants access to it.