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.
Bookmarks