I work with reports that seem to take an age through double entry. Is it
possible to do the following, and if it is; how?

Enter information into a row of cells in a workbork (A). This same
information then transferred to another workbook (B )in the first available
row, i.e. following on from the previous entry.

Then the information in workbook (B) subclassified by certain entries to be
entered onto other tabbed worksheets within workbook (B), again they must
enter the row following the last entry.

Thanks

Shaun K