Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can excel populate a list from another worksheet
I have a worksheet with basic information (name, address, etc with just a few
formulas [like calculating age] ) that I fill out interviewing a person. What I need is the ability to have that info populate another worksheet if they end up in our program, (some will, some won't). Is that possible with excel? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can excel populate a list from another worksheet
While that would be better accomplished with a database you can do it in XL.
Primarily you will be wanting to use Vlookup type formulas (or index/match) to relate the chosen individuals on one sheet back to the interveiewd peopl on the other. Hard to comment further without more info and like I said a Database would probably be a better options if you know databases or someone who could help you get one set up. -- HTH... Jim Thomlinson "Paulette" wrote: I have a worksheet with basic information (name, address, etc with just a few formulas [like calculating age] ) that I fill out interviewing a person. What I need is the ability to have that info populate another worksheet if they end up in our program, (some will, some won't). Is that possible with excel? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can excel populate a list from another worksheet
Thanks, I was told acess would be a better tool by someone else too. Guess I
better get the book out. "Jim Thomlinson" wrote: While that would be better accomplished with a database you can do it in XL. Primarily you will be wanting to use Vlookup type formulas (or index/match) to relate the chosen individuals on one sheet back to the interveiewd peopl on the other. Hard to comment further without more info and like I said a Database would probably be a better options if you know databases or someone who could help you get one set up. -- HTH... Jim Thomlinson "Paulette" wrote: I have a worksheet with basic information (name, address, etc with just a few formulas [like calculating age] ) that I fill out interviewing a person. What I need is the ability to have that info populate another worksheet if they end up in our program, (some will, some won't). Is that possible with excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forms that Populate Excel Worksheet? | Excel Discussion (Misc queries) | |||
use if statement in excel formula to populate adjacent from list? | Excel Worksheet Functions | |||
Lookup list from different worksheet & auto-populate multiple cell | Excel Discussion (Misc queries) | |||
populate cell on worksheet 2 if text is red on worksheet 1 | Excel Worksheet Functions | |||
can excel populate fields in one worksheet to another? | Excel Worksheet Functions |