Formula for Computer Name Generator

[Adamstorm15]

Hello,
I'm creating a Excel spreadsheet for device names for my company, but I'm getting a little hung up on this one part. We have a location base naming scheme, Building-Floor-Dept-Device Type-XX(2 digit #). So what I want to try and do is on the first tab of the spreadsheet have the a drop down menu of each section of the name, where I can choose each section. Then have the newly made name appear and automatically get sorted in another tab based on the dept name.

Anyone has any ideas?

[XOR LX]

Hi,

If you post a small sampe worksheet with your desired results in that would be great.

Regards