Excel Based Contract look up and fill in
Closed
MusoContractor
-
Feb 2, 2010 at 02:26 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 2, 2010 at 03:07 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 2, 2010 at 03:07 PM
Related:
- Excel Based Contract look up and fill in
- Number to words in excel - Guide
- Gif in excel - Guide
- Marksheet in excel - Guide
- How to take screenshot in excel - Guide
- Excel free download - Download - Spreadsheets
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 2, 2010 at 02:39 PM
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
I presume that you would be typing in a SSN in one cell and other cells would populate info like Name, DOB, address etc
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 2, 2010 at 03:07 PM
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 .
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 .
Feb 2, 2010 at 02:48 PM
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