update values between sheets

[john_cash]

Hi to all,
in the attached workbook you have to do this
in "articoli" sheet
IF E6 < J6 OR E6 = J5
bring the row into the sheet "sotto_scorta"
I hope I have explained
thanks
john

[Kaper]

try such macro:

Please Login or Register  to view this content.

[john_cash]

Hi kaper, thank you
A change:
in the "articoli" sheet the lines must remain in the same place, they must not be eliminated

[mohadin]

Please Login or Register  to view this content.

[john_cash]

Ops kaper
i changed here

.Rows(i).Copy Sheets("sotto_scorta").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).EntireRow

[john_cash]

Thanks also to mohadin

[john_cash]

I tried the kaper macro in another workbook.
must copy the non-blank rows of column B

[Kaper]

Try:

Please Login or Register  to view this content.

Non-empty part is marked with red. I also changed the sequence of copyint to top=to bottom one (blue) as you are not moving, but copying rows. (For moving bottom to top was easier to implement.)

[john_cash]

Hi kaper the macro works almost fine.
I linked the macro to a button and clicking on the button
the rows in the sheet "sotto_scorta" are repeated.
Another thing:
it is possible that the rows are brought into the sheet "sotto_scorta"
without colors, formatting

[john_cash]

I solved it by adding macros created with the recorder:

Please Login or Register  to view this content.