Thread: Create two identical userforms

Hello, here is my problem: I have an excel file with 5 sheets (N-1 Inventory, Inventory N, Lists, Report N-1 and RL-N) I want to do an extraction via an advanced filter my inventory sheet N-1 and N to N-1 Reading and N. I managed to do with the inventory sheet N, I defined names, my combobox will look in these names, include in the paper lists (A2: C2), I sort through these three terms and Finally, I copy the sorting sheet Statement N. My problem is that I would do exactly the same with the inventory sheet N-1 using a different userform and stating that copies the data found in the combobox on the sheet lists but that E2 and G2 performs sorting and copying all in the leaf N-1 statement. Thank you in advance for the help you can give me

Hello, Well, I want to be in your place! For UserForm I see no point in this kind of situation . If you do a sort of three columns I guess it's because you do not have a single reference (Index) and it will not simplify the problem. I think the best is already make an index by concatenating the three columns in each sheet. Yapuka then make loops that run through all the inventory sheet N-1 and you restore the data or you want and in whatever order you want.
Mebon With coughing info as I can not say more!