Excel Based Contract look up and fill in [Closed]
Report
MusoContractor
-
rizvisa1
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
Related:
- Excel Based Contract look up and fill in
- Macro to insert row in excel based on criteria ✓ - Forum - Excel
- Duplicate rows in excel based on cell value ✓ - Forum - Excel
- Merge rows in excel based on criteria ✓ - Forum - Excel
- How to change text color in excel based on another cell value ✓ - Forum - Excel
- How do i automatically add rows in excel based on cell value - Forum - Excel
2 replies
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
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
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
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 .
Subscribe To Our Newsletter!
DON'T MISS
- How to Get Free Diamonds in Free Fire
- Computer Boots to Black Screen
- How to Recover Your Yahoo Account
- How to Create a Gmail Account
- How to Fix a Blurry Snapchat Video
- Facebook Code Not Received
- How to Upload High Quality Photos to Instagram
- How to Recover a Disabled Facebook Account
- How to Get More Followers on Instagram
- How to Disabled Write Protection on a USB
- How to Install a VPN
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