"Input Sheet" template

K

Kev

"Input sheet" that distributes data to other worksheets.
I wish to create an "input template" that based on the
name in a "customer" cell it should place the data in
that customer's row on various worksheets. This data
needs to be retained on those worksheets even when a
new "customer" information is used on the "input sheet".
Does such a function exist or am I about to learn VBA?
 
D

Don Guillett

You are about to learn vba. You will need a macro that takes the info from
that cell or row and transfers to the next available, or specific,
row(column) for the specific customer. Post back with more details and
someone will assist.
 
K

Kev

Have a "customer" cell on "input' sheet that will
determine which row on the data worksheets the
information will be placed into. This "customer" cell
gets a customer name through a vlookup on "input" sheet.
Have a table/grid (13 columns x 20 rows) on "input" sheet
that you enter numbers into.
Need to have data from the input sheet, transferred to 20
data worksheets (all data sheets have the same layout)
although different layout to table/grid on "input" sheet.
Each row in table/grid goes to a separate worksheet but
there is an additional column on each worksheet
separating adjacent data on the table/grid.
Once you finish entering customer data into input sheet,
you change customer number and commence entering next
customer's data.
Customer's data remains in the data worksheets until you
re-enter new data for this customer.
Many thanks
Kev
 
Top