Previous Topic Next Topic

Excel Based Contract look up and fill in

Closed
MusoContractor - Feb 2, 2010 at 02:26 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 2, 2010 at 03:07 PM
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

Answer 1 / 2
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Feb 2, 2010 at 02:39 PM
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
0
MusoContractor
Feb 2, 2010 at 02:48 PM
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
0
Answer 2 / 2
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Feb 2, 2010 at 03:07 PM
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 .
0