Hi, please help! On sheet 1 i have various info, some of which is fed through
to sheet 2.

Sheet 1) Sheet 2)
| Data from sheet1 |
A1 A2 A3 A1 A2 A3
A4
Name Ref Date Name Ref Date
Y/N

I have used the unique values formula to pull the names etc from sheet 1 to
sheet 2, this automatically puts them in alphabetical order (which is great).
On sheet 2 i also add data in other columns, which is relevent to each
person. When a new name is added on sheet 1, obviously the names move order
on sheet 2, but the additional data added in other cells doesn't! Is it
possible to make the whole row move? Please tell me it's easy!

Thanks

Becks

P.s. I posted this question some time ago, but only got one reply, that
didn't help, sorry for re-posting but i'm desperate!