K
Kev
Have a "customer" cell on an "input' sheet that will
determine which row on the data worksheets the
information will be placed into. The "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
determine which row on the data worksheets the
information will be placed into. The "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