Fantasy Football Spreadsheet Macro for automation

[gmacdaddy89]

I honestly know nothing about macros and dont even know if one can be written to do what I need but maybe someone can help me. I am creating a fantasy football database using excel that tracks the pertinent fantasy stats in my league for every player in the NFL. Right now I have a sheet for every single week. A master sheet with every player's name on it and a sheet for every position. The master sheet lists the players names in column A and the weeks of the season in row one. In each cell, I have entered an If/then formula that populates an "X" if the player recorded any stats for that week.

I want to be able to use a macro that recognizes an "X" is in that column, and then on the related position sheet enters the vlookup forumla to pull in the stats. The problem is, I need it to be able to adjust so that it can include up to 16 vlookup formulas. If there is no x in the box then I dont want the vlookup formula to be populated in.

This may be confusing and I tried to explain it as best as I could, so if you need any more clarifications as to what I want please ask. And hopefully you can help me build this to do what I want. THANKS.

[swoop99]

You're right, it is confusing. Can you post your workbook?

[gmacdaddy89]

How do I do that?

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly. They also explain everything else you need to know.

Thanks.

[gmacdaddy89]

I honestly know nothing about macros and dont even know if one can be written to do what I need but maybe someone can help me. I am creating a fantasy football database using excel that tracks the pertinent fantasy stats in my league for every player in the NFL. Right now I have a sheet for every single week. A master sheet with every player's name on it and a sheet for every position. The master sheet lists the players names in column A and the weeks of the season in row one. In each cell, I have entered an If/then formula that populates an "X" if the player recorded any stats for that week.

I want to be able to use a macro that recognizes an "X" is in that column, and then on the related position sheet enters the vlookup forumla to pull in the stats. The problem is, I need it to be able to adjust so that it can include up to 16 vlookup formulas. If there is no x in the box then I dont want the vlookup formula to be populated in.

This may be confusing and I tried to explain it as best as I could, so if you need any more clarifications as to what I want please ask. And hopefully you can help me build this to do what I want. THANKS.

[gmacdaddy89]

i will be posting my workbook in a couple of hours

[gmacdaddy89]

The sheet called rosters has the "x's" on it indicating the weeks played, and the sheet called WR stats indicates the vlookup formulas.

Thanks

[gmacdaddy89]

Can anyone help me with this problem? My spreadsheet works for what I need it to do without a macro, but it would be really nice to have a program that can automate more of the process

[cbayly12]

Hey,

I'm creating a similar spreadsheet, and was wondering if you figured it out?

[gmacdaddy89]

I actually moved in a different direction with the information that I had, but I am willing to take a look at what you have to see if I can help you out with what you are looking to do.

[cbayly12]

Well I am starting a Suicide Fantasy Football league. I started a basic spreadsheet, but realized it would take a really long time to update by hand for each entry. For instance: Team A picks Drew Brees as QB, is there a way to have a macro automatically pull his stats for the week and use my formula for scoring to update scores?? I'm looking at your spreadsheet and it's very impressive. I notice you have tabs at the bottom of your spreadsheet for the week by week stats. Did you type those by hands or pull those from a website??

[gmacdaddy89]

I had to type in the stats on a week by week basis because I dont know how to pull things directly from websites and get them into excel. I pretty much entered all of the formulas and everything by hand. I am actually using this site to figure out how to make more of my spreadsheet an automated process because I am not extremely well versed in the technical side of excel. As you can see I even had to enter in my formula for scoring information which I would love to be able to change to have automated. I am sorry that I cant help you out with this as I am still looking for ways to improve my own database. I would love to see what you have put together and maybe we can bounce ideas off of each other or something.