![]() |
Create a master worksheet based on 2 different worksheets
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? |
All times are GMT +1. The time now is 11:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com