Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

Tricky Excel questions for the experts!

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Tricky Excel questions for the experts!

Old 11-21-04, 08:29 PM
Senior Member
Thread Starter
Join Date: Nov 2001
Posts: 245
Likes: 0
Received 0 Likes on 0 Posts
Tricky Excel questions for the experts!

I have a spreadsheet that I working on that I have incorporated a drop down list of all countries into. The drop down list is in a cell in Sheet1. The list itself is taken from a range (named Countries) on Sheet2. Also on Sheet2 is a list of ISO-agreed country codes, appearing in the next column along and corresponding to the correct country.

My questions are:

1) Is there any way that the drop down list can operatie in a predictive manner? I.e., instead of me having to click the arrow, then scroll all the way down to Sweden, can I type S in the cell and the box will automatically remove any country not beginning with S from my choices, and then if I type "Sw" it narrows it down to the three countries that begin with Sw?

2) Secondly, when the user has chosed Sweden, I want another cell to display the internationally recognised country code. I actually want it to display it as part of a series of other things, but I think I have got my head around the Concatenate function to be able to incorporate whatever the solution is into my cell.

3) Lastly (for now) I have spent the last few hours working on this project for work, and I'd like to protect my time and effort, so is there any good way of hiding and protecting my formulae so people can't alter it or strip it and use it as their own?

Thanks for any help

Old 11-22-04, 08:49 AM
DVD Talk Legend
Join Date: Aug 1999
Location: Chicago, IL
Posts: 17,205
Likes: 0
Received 0 Likes on 0 Posts
1. Use Filters
2. Use IF statements
3. Hide columns and there might be a way to hide with password protect

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.