ADP problem

[dwagner13 0]

Is there a reason why the ADP for everyone (and I mean EVERYONE) is appearing as 2.05?

[Mike MacGregor 20]

Not sure. Is this in the Compiler or Draft Buddy? The ADP tab or on the cheatsheet?

[dwagner13 0]

It is in both the Compiler and DB. In Compiler, it is the Cheatsheet Tab and in DB it is the Offense tab.

[dwagner13 0]

I just checked and it is a problem with the Macro to Compile Cheatsheets. There is only a formula in "Cheatsheets" tab cell G8

 

=IF(ISNA(VLOOKUP(C8,ADP_10team_lookup,3,0))=TRUE,"",VLOOKUP(C8,ADP_10team_lookup,3,0))

 

This formula is not located in the rest of the cells, only the value of cell G8.

 

I copied the formula to the other cells and it generated the correct values; however, when I compiled the cheatsheets again with the macro, the ADP reverted to the formula in G8 and the value of G8 in the other cells.

 

Hope that helps you Mike.

[Mike MacGregor 20]

What version of Excel are you using D? The Compile Cheatsheets macro should place that formula in the first cell, copy it, and paste it to the rest of the cells as a formula. Anyone having this problem?

[dwagner13 0]

Excel 2003. It puts the formula in the first cell and then must be copying the value to the rest of the cells.

[Mike MacGregor 20]

Yeah, and I'm not sure why it would be doing that, because the macro specifies it should be pasting the cell as a formula. Can you send me over your copy of the Compiler because I want to test this first hand? compiler@fftoday.com Please zip the file first if you could. Thanks.

[dwagner13 0]

Mike,

 

I know why it didn't work. I had protected the worksheet and when I ran the macro it just copied the value from the first cell to the rest. When I unprotected the worksheet and ran the macro, it worked just fine.

 

Thanks for your help.

 

Doug