First time doing this.. but.. This is worth 30usd to me? (I'm guessing paypal is easiest?)
I haven't found online
examples quite like what I'm trying to do, but I think it's do-able and quite easy?
I have a worksheet where each
row is an individual. To the right of this I want some users to populate the employee numbers of who they feel could replace
them if that individual left the company.
Because we want these replacements as employee numbers (so that we can
populate additional sheets/do vlookups), and the number of possible candidates is quite large (1-2 thousand), I want to
provide a search form they would use to find each replacement. This will allow more accurate data entry while still keeping
the document in excel format, which they are familiar with.
So.. What the data looks like (as per first attachment
User,~extra data~,Replacement 1,Replacement 2, Replacement 3 etc....
Employee ID, First and last name, Last Name, First name, ~extra data~
Note that the last/first names on sheet two
will be calculated (I'll use a formula to extra the First/Last names from the concatenated name in the 2nd cell). I'm doing
this as I believe to allow searching on first/last name separately they should be in different columns.
Triggered by either clicking the "replacement" cells, or selecting the cell and starting the macro (ctrl function perhaps?)
I'd like a search form to come up.
Search form would show 2 boxes:
and a search button.
Entering either or both lists any matches (using wildcard search) and their matching employee
number. If the user doubleclicks any of the results, that user's employee number is pasted into the originally highlighted
-User clicks one of the "replacement" cells on the first worksheet and starts the macro. If clicking the cell it'self would
trigger the macro/form (or perhaps hitting a combination of keys) that would be ideal.
-Search form appears.. User
enters first and or last name and clicks search.. matching results (based on first/last name from 2nd worksheet appear)
**Note, would be desirable to show results as their first/lastname plus their employee number.
-User clicks the
correct user (if there are multiple results).
-That employee's employee number gets populated to the cell they
selected before starting the macro.
I've attached a simple workbook showing what the data looks like:
Closest I found to this was here:
But that one returns the sheet the matching user(s) is on,
then brings you to that sheet/row if you click it.