K
Kev
I am wanting an INPUT sheet of 13 columns, 20 rows.
Entered data will be distributed to various worksheets
based on a customer name field (selected from a drop down
list), and the entered datas' position within the input
sheet. Data is to remain static in the "distribution
worksheets" until that customer is selected for new or
more input.
What is the best option: 1. a user form OR 2. a worksheet
with a range of cells for data entry?
How can I retain previously entered data in the
distribution worksheets for a customer when a new
customer is selected on input sheet?
I was thinking of having a command button that controls
when the data is transferred to the distribution
worksheets. Its first action is to establish the new
customer's range on the data sheets prior to any data
being transferred, thereby leaving other customers' data
static.
Thanks to all for their assistance on this and past
postings..
Kev.
Entered data will be distributed to various worksheets
based on a customer name field (selected from a drop down
list), and the entered datas' position within the input
sheet. Data is to remain static in the "distribution
worksheets" until that customer is selected for new or
more input.
What is the best option: 1. a user form OR 2. a worksheet
with a range of cells for data entry?
How can I retain previously entered data in the
distribution worksheets for a customer when a new
customer is selected on input sheet?
I was thinking of having a command button that controls
when the data is transferred to the distribution
worksheets. Its first action is to establish the new
customer's range on the data sheets prior to any data
being transferred, thereby leaving other customers' data
static.
Thanks to all for their assistance on this and past
postings..
Kev.