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