Hello again
I want to ask you, I do not read properly or you can not help me.
Absolutely no one helps me.
Looking for help from you know, if I knew how to do it would write to you.
Why are these names to me, why should I search so many drop-down menus, why, why ..........
Because I have a database of over 46,000 names in each Sheet repeated, but the order of each name there are other things that need to get out (remote) copy, as you call it, and each sheet is under a particular name in it the name of a person can be displayed 20 times and this line is other data that I need.
Surely he could not imagine how it is laborious to seek so much.
Ask for names I have to copy sheet (SEARCH) but not in the English language and the system will not recognize them you will read the characters, so I gave the example of numbers, it can be a number, then I will change my numbers with my real name.
For ease I will say this:
Column T: T is now this - >> ComboBox1.AddItem "1" (T1) to T970 to you more easily replace it with the following: T1 - Charles1, T2 - Charles2, T3 - Charles3 and so T970 - Charles970.
So now all remaining sheets 15-20 number of them have all these (Charles and some number) (but I have names) Click on the first combobox and choose Charles3, clicks and choose Combobox as Charles548 and so as I need. As found in columns D: D all Sheets -> Charles3 (eg 25 matches) starts searching from the next Combobox - selected name, which in this example is Charles548 (eg 13 matches) in all Sheets and so to the end. These names are the same in all the sheets(15-20) and my base is in Column T: T and can be as you say .List
Reply With Quote
Bookmarks