creating Fantasy Baseball Spreadsheet

Hello,

I am creating a spreadsheet for fantasy baseball draft day.

What I want to do is be able to insert information from a separate sheet database, that corresponds to the drafted player.

For example, each player would have 5 columns per row (not including the player's name), worth of data attached.

Here is an example:

Albert Pujols .320BA 45HR 120RBI 115R 15SB

What I want to be able to do is type out a players name, and auto-fill not only the name, but the entire row of attached statistics from the database sheet.

I am learning Excel, so I'm not real savvy, but I would appreciate any help.

Thanks

Okay, just to make this specific to my spreadsheet, here is the layout:

Rows 1 and 2 are headers going across.

Row 3 has columns labeled :

POS NAME AVG R HR RBI SB AB

Rows 4 through 18 will include the players names and statistics.

Column A is already set and not to be edited (they are the positions), but Columns B through H would all be edited (NAME AVG R HR RBI SB AB)

The other sheet is named : Players Database.

http://img3.imageshack.us/i/baseballscreen.jpg/

The link is a screenshot of the spreadsheet so far.

So what I'm trying to do is have a search box for the player names in B4 to B18 cells. Once the player is selected, I'm trying to allow the pre-existing 5 columns of data to be automatically inserted into the 6 blanks columns for that particular row.

http://img141.imageshack.us/i/baseballscreen2.jpg/

Here is a screenshot of the database page, where I am trying to pull the data from.

Cutter,

Thanks, I'll check it out to see if I can get it working right.

I just started using Excel, and find it very useful and interesting. So far I've figured out how to do basic stuff, like sums and weighted averages. I'm hoping to become educated enough to use it for other things.

Sweet! It is working now. One more thing though...

Is there a way I can automatically have the name typed in based on the first few characters?

i.e. Puj ---> Pujols would be inserted

Either that or a search box would be awesome.

I added further info to my last post. Have a look there.

Thanks! Appreciate it.

You're welcome. You should mark this thread as SOLVED (click on the FAQ button at top of page for directions).

If you need help with the DNR and/or DV you can start a new thread.

Originally Posted by deadmanramsey

Is there a way I can automatically have the name typed in based on the first few characters?

i.e. Puj ---> Pujols would be inserted

Here is the only way I have figured out to do something like that. You have to use VBA.

(There is no way to detect when a change is made while typing in a cell that is open for editing. You can detect when the user selects the cell, and after it has been changed, but for autofill you have to be able to detect every time a character is typed. However, you can detect changes in a textbox.)

This solution brings up a form if you select a cell in column A. As you type in the textbox in the form, there is a lookup for a match in the player list. If it finds a match for what you are typing in the text box, the matching player's name appears in the selected cell. If you like the match, click OK (hitting ENTER twice also works).

It's not the ideal interface but let me know if you find it useful.

New and improved. Shows type-ahead characters in red (tried as I may I couldn't get it to work with gray).

attached below is a sample draft from sirius radio TAUT WARS AL only auction this week. everything works great for the typical $260 salary cap and 23 player roster. my problem is that my league uses $26 cap with salary increments of $0.10 instead of $1.

for the first team listed, i changed the formula to $26. The "left to spend" and "players needed" are working just fine, but the "MAX BID" is not.

feel free to use this nice template.

Hi. Just stopping in to say thanks for the info in this thread. A year later-3/23/2012 and found this info doing a search for "fantasy baseball excel". Used the "tout wars" template one of you put in here a year ago. Will take laptop and Excel tracker sheet to my live 7 hour auction draft tomorrow.
Anyway, thanks again.

T