Excel Based Contract look up and fill in
Closed
MusoContractor
-
Feb 2, 2010 at 02:26 PM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Excel Based Contract look up and fill in
- Macro to insert row in excel based on criteria ✓ - Forum - Excel
- Auto serial number in excel based on another column ✓ - Forum - Excel
- Macro to insert row based on variable cell value (text) - Forum - Excel
- Duplicate rows in excel based on cell value ✓ - Forum - Excel
- How to move rows automatically in excel based on cell value ✓ - Forum - Excel
2 replies
rizvisa1
Feb 2, 2010 at 02:39 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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
Feb 2, 2010 at 03:07 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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