Cut/Paste and Update Values between two sheets (losing rows)

Good Evening,

I'm stuck with this code and I really don't know why, I think that it's a range issue but I can't see it so i thought that you may help me spot it.

I've a range of data between columns A to R, with a month in R, and a droplist with months.

I wished to get the data in the "DATA" tab to be displayed in the "JLOP" tab depending of the month value in R,
this data was then removed from the DATA tab, and when a new month was selected, pasted from JLOP to the Last row of DATA.

But, everytime I run it, I lose more and more data.

I thought that it was because I needed to calculate a new Last Row (LRDATA2) or because I would lost 1 row each time (that's why I did LrDATA + 1)
but I'm losing way more data on every loop...

I also thought that it might be caused by the ranges used (not starting in A1 etc) but i'm not losing the same number of rows on each loop.

I know that on the example below, I start with the JLOP one instead of the DATA tab, but that's just so that the script starts with an input.

Could you help me please or suggest me any improvements please?

The sheet is full of Employees data so I can't provide it, but I can send an example if needed.

Thank you very much and sorry for my english.

Please Login or Register  to view this content.

Best regards,
Picsou

Hi, sorry if it took me long to answer,

i've managed to fix this issue by calculating a new lastrow

Please Login or Register  to view this content.

and by splitting the file in several calculation steps.

Many thanks,
Picsou