I would like to enter data (i.e. name, address, phone, facility...) once and
have the results entered into two separate worksheets. One worksheet being a
compiled list of all entries. The second worksheet(s) would be by location
(would be more than 100+, i.e. smallville, largville, mediumville). Is there
a way to accomplish this?