Excel Question: Pre-populate based on Drop Down

[Prototype]

Did a quick skim to see if this had been asked yet, didn't see it.

I'm in a Sim League that is heading into it's draft right away. What I'm trying to do is come up with an Excel sheet that keeps track of who is drafted and by what team.

There are two parts to this.

I have two sheets so far in the document I'm working on. One has the Draft Order of the teams in the league, the other has the results of the NHL, including the player's vitals.

I have a drop down menu in the sheet with the draft order which has each player, alphabetically. What I'm trying to do is have the vitals pre-populate after selecting the players name.

What I'm also trying to do is have the Sim League draft ranking populate in the sheet with the NHL results as well.

While the draft is on going, I want to post this to google docs so that the entire league has something to look at while the picks are being made.

I hope this all makes sense. If you need more info, feel free to post, or PM me.

Thanks in advance.

[Prototype]

Found the first part. Trying to find the 2nd part.

[Prototype]

Got. MODs, feel free to lock thread.

[Teh_Bandwagoner]

Good work team!

[fundmark19]

I have an excel question hoping someone can help me out with I have a macro that I run for search that highlights a specific cell with what ever I search. So in my case I am trying to find account numbers that include a specific letter. Now one of my searches includes a letter that each account number has in it. Is there a way to set a search to find only accounts that have the letter twice?

All accounts are set like this ending in a letter
Ex 6b3394e

I want to find all accounts that include 2 b's
ex 6b3394b

If I use my current macro it will highlight every single account on my spreadsheet

here is link to website where I get my current macro from
http://www.pcadvisor.co.uk/forums/1/...earch-resukts/

[Rathji]

(.-b)*b(.-b)*b(.-b)*

[fundmark19]

I don't think that formula will work in excel find

[Rathji]

Originally Posted by fundmark19

I don't think that formula will work in excel find

haha, no it wont. I was just messing around.

[fundmark19]

I can't send spreadsheet since it has peoples account #'s on it and I don't want to get fired even though the random numbers would mean nothing to you. Anything simple I can try?

[fundmark19]

Is there a way to sort using the last character instead of the first? That would make it easy

[fundmark19]

Originally Posted by fotze

Are the numbers always 7 digits long? Is it always number,letter,number,number,number,number,letter,n umber?

If so its easy.

=IF((RIGHT(LEFT(A8,2),1)&RIGHT(A8,1))="bb","YAY"," BOO")

where A8 is the cell with the acct number.

yes they are always 7 long you had it but added an extra number

number,letter,number,number,number,number,letter
First letter is always B and I need to search for the second letter that is also a B

All account numbers are in cells a1 to a1796

[fundmark19]

Thanks fotze isn't perfect like the highlight macro but will work just fine

[SebC]

You should be able to use the fotze formula in the conditional formatting wizard.

[Titan]

Originally Posted by SebC

You should be able to use the fotze formula in the conditional formatting wizard.

There is a pretty good joke in here somewhere...

NEVER use the Fotze formula if the person can turn you into a frog? nah.

You can use the Fotze formula but the outcome of the wizard is always T&A? nah.

I used the Fotze Formula in my truck and now it smells like fish? not bad.

Maybe it is too early...