Hi all

I am trying to find a function that will copy 4 adjacent cells to another
sheet within the same workbook and place them at the next empty row in the
required sheet.

I have one master sheet and wish to copy specific data based on a user id to
that users worksheet.
Three sheets named Master, Person 1, Person 2.

Excel 2007 and Vista Home premium.

All help will be very much appreciated

Double R