Hi Charles,
I try to read what you wrote to me, but again I come to my explanation, but said a little differently.
Again I will try to explain.
(1) In my previous post helped me with the code, when I type the name in cell A1 and pressed the button to check all sheets and gave it to the main sheet.
Here is the same - only have 60 drop down menus for office work more than 40 people, everyone is looking for his name.
So - we have a dozen sheets 15-20, people's names are in column D on each sheet, if Userform write 5 names> only to find them again if I write 45 to look for them, if I write the same 60 to find them and cause them (put) in sheet (SEARCH) starting at cell A2.
It is the former which helped me - >>
http://www.excelfox.com/forum/f2/sea...-purposes-861/ -> (1)
Please check out this file and macro in it to be able to gain some insight (attached).
If there's anything else ask me, I will try to explain.




Reply With Quote
Bookmarks