I have grabbed a file where by entering an X in lets say line G7 on sheet 1,
it transfers all of line 7 (A through to F) onto the next available row on
sheet 2. It doesnt explain how it is done though - any starting point for me?

I would like to use it for building a list from a large selection of records
- like a customers order for instance.