Hello,
What I am trying to do is create a part of a macro that will look up an entry in a form, find that related cell and then enter in the rest of the form from there. The reason that I say part is that I have the form formatted already (mostly).
So for instance the form would read as:
Room Number: 12
Name: Bob
Address: The Universe
So 12 would be looked up in colum A and then Bob and The universe would be entered in the corresponding row in columns B and C.
Hopefully this makes sense and thanks in advance!
Bookmarks