Multiple Worksheet Change

[excelnovice19]

First, my workbook works. It's not as most experts would have it but it works. However, I have additional time and thought I'd post to figure out something I could not. The attached workbook is for a baseball draft. Most of the data has been removed to restrict file size. However, when a player is selected (Sheet 'Draft') he's automatically populated onto Sheet 'Grid' without having to manually select Sheet 'Grid' I have no issue here. My issue is I cannot additional sheets to automatically update accordingly (i.e. without physically selecting the tabs).

I have the following macro for Sheets 'Hitter Data', 'Pitcher Data' and 'ADP'. I call the macro upon sheet selection (basically, the macro is stating that if a player is drafted on Sheet 'Draft' his appropriate row is hidden).

Please Login or Register  to view this content.

Again, it works. However, I'd like to automatically perform this without having to select the appropriate sheet. I assumed this would be a multiple worksheet change occurring in Sheet 'Draft' (whenever any change occurred in 'Draft'$D$4:$D:$1004). However, I could not get it to work and did it the "novice" way. However, I'd love to see this work as intended.

I've attached the sheet for reference.

[dflak]

I see something missing here, namely: the position the player is being drafted for. You will need that to fill in the roster.

You will need "normalize" player data, but you seem to have that with Hitter and Pitcher data.

I recommend as you do the draft that you build a normalized database with team, player, position. The rest of the information can be looked up from either the pitcher or hitter data. Building a normalized database makes the spreadsheet much more powerful. You could then get most of the information you want through a series of pivot tables.

You could also do the draft on a user form by round and after each team picks, the selected player would be deleted from the list of players that can be chosen.

All these are suggestions for improvement except the first one. You can't fill in a roster without knowing what position the player is being drafted for.

Also, I'm not sure what the ADP sheet is used for and how the grid in columns C:N are filled in.