Jump to content
[[Template core/front/custom/_customHeader is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]]

Need Excel advice on copying/modifying huddle rankings


kcmast
 Share

Recommended Posts

I've copied in the top 120 and huddle ranking by position to Excel. I've also adjusted the rankings to my planned draft order. On draft day, I like to set the cell color to show that a player has been drafted. Is there a way to link the two cells from multitple sheets so that by setting the cell color for Larry Johnson in the top 120 it also fills in Larry Johnson in the list of RBs? I tried defining a name on one sheet and then using that name on another; it transfers the name but not any coloring.

 

Example Larry Johnson is in cell C2 on my top 120 (sheet1) and in H3 on Top by position (sheet 2).

 

Thanks!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information