As long as it isn't too much trouble to navigate to the correct sheet
yourself you already have a Form to use: Click anywhere in the list & go to
Data> Form. It will automatically append each record you add to the bottom
of the existing list. It will also carry forward any formatting &
calculations from the previous record.
If you're talking about a form that will distribute each record to separate
sheets it will have to be handled programmatically & include some sort of
device or code to enable it to determine what sheet the record should go to.
Quite honestly that actually leads to more of the inaccurate entry you're
trying to avoid. IMHO it's far better [and easier] to regulate the workflow
to enter one type of record at a time.
You might also look into using the List Manager.
If none of this helps,
HTH |:>)
Bob Jones
[MVP] Office:Mac
provide a more explicit description of what you are starting with & what
you actually need to do.
