How to setup dependent drop down list...?

Dear Forum experts,

Request your assistance in setting up a dependent drop down list.

Please advise and assist!

Regds,
Spi

I await help on this please assist.

Thanks!

Dear John,

First and foremost, please accept my apologies for this late response. I'm away from work with no access to a computer. I'll be back on Wednesday, and will post a file with example.

Really appreciate your time, and apologies for this unintended delay.

Thanks a lot!

Regards,
Spi

Dear John,

Here's the workbook with the desired results.

Sorry about the delay! I was away for the past few days with very limited access.

Regards,
Spi

Hey John,

Just facing a small issue after I added my complete list into the Database tab (There are about 2000 rows of customer names along with email addresses) and added all the customer names to the Lists tab (column A). It is giving me a run time error 1004. No cells were found.

Could you please advise as why this may be happening or if I'm missing anything...

Thanks,
Spi

Point 1 - My Bad!...Yes I understand it now. I don't need to add the names manually.

Point 2 - I guess I need further assistance. The error is appearing on this line

Please Login or Register  to view this content.

. It appears that the population of email address is dependent on the subject line and not on or ONLY on the company name. The error occurs whenever Column G in Database is blank. Am I correct sir?

I'm using simple numeric values 1 - 2000 as the customer names while testing to avoid and issues and understand how it works. Trying to keep it simple. Hope I'm not making it complicated by doing this

Sorry for all the trouble. The subject line is to be used as a secondary drop down which is my next phase when the body of the email is to be related to it, but I want to concentrate on the above and understand how it work first

Regards,
Spi

Here's the file.

Thanks!

Thanks John. This worked like a charm!

Would you be okay helping me with the last phase of this request? I need to be able to append the body of the email by using the subject line as the filter. If yes, I can go ahead and post the sample after doing all the ground work with examples by Tuesday. Please advise.

Nevertheless, this has been a tremendous help. Half the battle has been won

Very much appreciated!

Thanking you for all the help. It surely wouldn’t have worked without your help!

Have a great weekend. Cheers!!!

Hi John,

It actually is a part of this request and is related to getting the mail body via excel. The greatest challenge is that there are about 30 odd different customized emails that I need to relay to my recipients depending upon the scenario. The choice will depend upon the subject of the email and will need some data to be pulled and incorporated in within the body depending upon the case and recipient.

If you suggest, I'll be more than happy to start a new thread after closing this one as "Solved". Please advise.

I'm currently working on a sample to derive the way I need the output, and will share that in 2-days time. I'm trying to be as clear as I can be on my request!

Really appreciative of the help and guidance! I've seen few other solutions by you and they all are exceptional.

Please advise. Have a fantastic weekend!

Regards,
Spi

I'll take your word and go by it. This part is solved to perfection. I'll need some help to chose the body of the email based on the subject line.

I'm working to get the logic's and email variations in place and should get back with the examples shortly. As you suggested, I'll PM you the link as well once I've posted it.

For now, going ahead and closing this as solved.

Very much appreciate your help and assistance!

Regards,
Spi