That is always a good idea, as I'm not fully convinced you need VBA, plus, it's hard to create VBA when you don't know the real design of the sheet.



How about you put together a small representative sample of what you have and what you desire! Attach here.

Here is a copy of my first sheet. Players submit picks to me and I enter them into spreadsheet. This sheet is master sheet. So I make all final changes here. So for example Jacksonville won this morning. So I would like to put a w in it and it will fill across the spreadsheets. All of the ones that are bold in the next 120 sheets are the only ones that matter and will receive points.. Hope that helps.

Attached Files

SAMPLE NFL.xlsx (14.8 KB, 11 views)