Macro to sort out if item out of stock

hi, traga2whiskys, please check attachment, run code "test"

Watersev

Thank you very very much... this problem was way out of my league.

A big thanks again.

All the best.

Waterserv

Sorry to disturb you again, i just notice that the function is doing the opposite, instead getting from "Setembro" is getting for "Outubro"... how can i change that?

I was reading all of it, but it is too much info for me.

Thanks in advance

OK i think i maid it.

I swap this:

With Sheets("Outubro")
se = .Range("b15", .Cells(Rows.Count, "b").End(xlUp)).Resize(, 12)
End With

With Sheets("Setembro")
ou = .Range("b15", .Cells(Rows.Count, "b").End(xlUp)).Resize(, 12)
End With

And now it is working!

Waterserv

By the way, do you know how i can select one column and tell it to sort by lowest number, or by AZ order, and then it sort automatic the complete row?

Just picture the sheet your function create, and then lets say i want to sort the Item Name but everything should be sort as the name, otherwise it would be the mess.

Thanks in advance

this would sort A column on the result sheet (added line is underlined):

Please Login or Register  to view this content.