Hello all

I have an Excel file with several worksheets, and I'm having trouble writing (and finding) a piece of code so that a column from one sheet , (say A10:A40) is automatically transferred 'live' to another sheet as the user enters the data, (all text).

Any help on this would be great.


Many Thanks