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
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
Last edited by john_cash; 01-14-2021 at 05:06 AM.
try such macro:
![]()
Please Login or Register to view this content.
Best Regards,
Kaper
Hi kaper, thank you
A change:
in the "articoli" sheet the lines must remain in the same place, they must not be eliminated
![]()
Please Login or Register to view this content.
Ops kaper
i changed here
.Rows(i).Copy Sheets("sotto_scorta").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).EntireRow
Thanks also to mohadin
I tried the kaper macro in another workbook.
must copy the non-blank rows of column B
Try:
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.)![]()
Please Login or Register to view this content.
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
I solved it by adding macros created with the recorder:
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks