I am trying to create a master client database from two individual
worksheets. My goal for this spreadsheet is two input two different types of
databases with client information, i.e. name, address, etc. on two different
worksheets, but as each name is typed onto each worksheet I want both sheets
to link to a master. Here is an example:
I put Joe Smith's information onto worksheet 2 and then I put Sam Smith onto
worksheet 3.
What I want is to type Joe Smith onto worksheet 2 and Sam Smith on worksheet
3 and their information to appear on worsheet 1, the master client worksheet.
Is this possible?