Adding information to a V-Lookup workbook via Message Box

[MantisTobaggan]

i am doing a V-lookup from a hidden workbook. i need to be able to add to the hidden workbook, if a name is not found... so that it will save it to the hidden list for the next time i run the macro.

what i am doing is looking for a person's name in the hidden workbook and the value that is returned to the main workbook is location they are from.

Hidden workbook contents:

barry sanders OK
matt leinart CA
cam newton AL

so now what i want to do is, if the name tim tebow is found in the list (on the main workbook) i want to be able to input the location information to the hidden workbook via some kind of message box along with the new name that was found. i want to be able to input the name to column 1 (don't really need to "input" this, so much as just take the info found fron the main workbook)... and the location to column 2.

i hope this is clear enough to get my point across. and hoping this is possible. thanks all!

[TMS]

Use an InputBox, not a MsgBox to get the location.

Are you happy with working out the next available row in the hidden workbook?

Quite often you will get a quicker and more effective response if you post sample workbooks.

Regards, TMS

[MantisTobaggan]

i don't really care if the input is added to the end of my hidden list of names and locations. i will try to create a simple mock up sheet and paste it up here. i don't want to post my full intentions because it would take forever to explain. how do the input boxes work as far as coding. i haven't used VBA since high school (12yrs ago) and i'm trying to refresh/reteach myself with google.

thanks!

[MantisTobaggan]

input box sample.xlsx

here is a sample i worked up. what i'm wanting is for v-lookup to run in column 3 in sheet "main", using the info in sheet "hidden". but, if a name on "main", isn't on "hidden", i want the ability to add the name and location to sheet "hidden" AND have it save there for future use.