automatically copy two columns to another worksheet

[cvanrooy]

I have a workbook with three worksheets. I would like to be able to have any new data entered in worksheet 1 automatically copied to worksheet 2 without
having me manually enter the data again. Attached is my file. Every time a new volunteer name is entered in Sheet 1 (Volunteer List), I would like it added to
Sheet 2 (Volunteer Hours). It would need to move both column 1 and column 2 (last name and first name). Thanks.

[JieJenn]

In worksheet 2 A315 enter ='Volunteer List'!A315 and drag it across to B315, and drag it down. If you want to get rid of the 0, right click your mouse, format, custom, and in the format field type "".

[bebo021999]

Sheet Volunteer Hours, cell A4:

Please Login or Register  to view this content.

copy to A5 and down as far as you like.
tip: Use Ctrl-C then paste special/Formula if you want to keep original format of cells

[Winon]

See WorkBook attached

[cvanrooy]

SOLVED. Thank you