Excel Based Contract look up and fill in [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
This is probably very easy for an Excel wiz...I have to fill out union contracts - similar to a worksheet - and have an Excel database of information. All i want to do is typ in a SocSec #, have it find the match, and then copy and paste the range of cells associated with that SocSec# into my contract.
Any help would be eternally appreciated

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
You seem to be looking for vlookup function
I presume that you would be typing in a SSN in one cell and other cells would populate info like Name, DOB, address etc

that's absolutley correct.
i want to type in a SS# into a cell, have it find a match, and then copy and past the relevant information (which spans an area 2 cells high by 24 wide) into the relevant new contract.
and then move onto the next SS3 input....
thanks
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
It is hard to tell exactly how this whole setup is being designed.

If you are looking for simply filter the SSN sheet based on what you are entering then would manually transfer the information into contracts, then I think you can look at this
https://ccm.net/forum/affich-252843-filter-the-data-in-excel-through-formula

In that example, there is also a master list. One types information in one cell and master is filtered based upon what was typed. This should give a good idea where to go about .

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!