Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data entry once, input into two worksheets
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? |
#2
|
|||
|
|||
Sure it's possible. But you'd need to give some indication of what cells
you enter your data in and how you determine the location. I'd suggest you just enter the data directly into the first sheet and use a worksheet change event to copy the data to another sheet. Regards Trevor "bpstuart" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data entry from two cells across worksheets | Excel Discussion (Misc queries) | |||
Multiple worksheet queries | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
data entry on multiple worksheets | Excel Discussion (Misc queries) |