Hi All,

I am trying to create a form in Excel which will contain 4 different value from another sheet.

The first sheet has four columns

Team
Surname
Initials
Cost Center

I need to be able to bring across the team and the cost code, then list all of the people who are in that team. Could some one help out with a way to do this?

Once i know a way to do this, i need to create separate sheets for each team and have the data go in.

Thank you.

Luke.