E
enquirer
Hi
I can create a standard column/row spreadsheet that requires an entry
in each field before the final field automatically creates a unique
sequential number to assign to a returns order. I can also create a
form to make data entry easy. What I don't know how to achieve is how
to join the two.
I wish to have a form for example:
Date (auto fill)
Supplier
Invoice Number
Part number 1
Part Number 2 (auto add rows for each parts line) (don't know how to
achieve this either)
Reason for return
Returns Number (auto fill, unique, sequential)
This data is then stored in a standard row/column spreadsheet.
I can do this by having 2 worksheets, 1=form and 1=standard with a1 of
standard=a1 of form etc, but how do I clear the form and move to a2,
for the next returns order?
Can anybody point me to some examples that I can learn from.
Thanks in advance enquirer
I can create a standard column/row spreadsheet that requires an entry
in each field before the final field automatically creates a unique
sequential number to assign to a returns order. I can also create a
form to make data entry easy. What I don't know how to achieve is how
to join the two.
I wish to have a form for example:
Date (auto fill)
Supplier
Invoice Number
Part number 1
Part Number 2 (auto add rows for each parts line) (don't know how to
achieve this either)
Reason for return
Returns Number (auto fill, unique, sequential)
This data is then stored in a standard row/column spreadsheet.
I can do this by having 2 worksheets, 1=form and 1=standard with a1 of
standard=a1 of form etc, but how do I clear the form and move to a2,
for the next returns order?
Can anybody point me to some examples that I can learn from.
Thanks in advance enquirer