Hello.

Firstly I would like to appoligise my rusty English.

I work in a small company where we have about 20 employees driving around. Every week they fill out a workform describing what they did, how many hours they used and what material they used. All of this is done by hand and is delivered in hard copys.

I want to build a database with all our inventory. The sheet would consist of a=name b=ean number c= amount.

When our men fill out "amount" in the inventory list, cells a, b and c will then be transfered to different sheet, so when the employees press print, he will only print out the inventory he used.

In other words: I want to create a full list which contains name and order no. When ever someone fill out the amount cell, the entire row is transfered into another sheet.

Can anyone tell me where to look, or which functions I should try looking at? If anyone have a small template I could use it would be even better. :-)