Populating multiple textbox with specific cell data based on single range

  • Good morning Oz crew! I've found a few things searching around but haven't actually found one that works specifically the way I require. I'm attaching a link to the spreadsheet / userform I'm using. Basically, if the user presses the commandbutton to display permanent employees, it should find all employees with "Comp" in cloumn I, and populate the appropriate cell values in the userform text boxes. I'm not copying all values associated with column I and I think that's what's throwing me off with this one. Any help would be greatly appreciated! Here's the link to the example.. https://www.dropbox.com/s/zt3j…Employee%20List.xlsm?dl=0

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!