First - THANK YOU to the ones who helped last fall with setting up the original sheet. I've run into a situation where I need to copy a set of rows w/formulas to different workbooks (all references are the same, etc.). I've tried everything I know to do. Everything copies just fine, but it doesn't pick up the already entered data to give me individual pitcher information (but I can see the overall combined total of all pitchers).
1. The sheet was protected (so the user cannot manipulate the formulas). Unprotected here for editing purposes
2. One cell referenced an incorrect cell (this has been since fixed)
3. When copying the new range to other workbooks/worksheets, the referenced data captures correctly for a split second, then shows all "0's" (range a15:I15 - a3010:i3010)
4. Rows 1:12 do not update when copying new (but same) info to new sheet, BUT, if one MANUALLY enters data, the stats for each pitcher is updated. (same thing happens when copying data Row 12:3010)
5. I've seen a formula error (cells referencing empty cells), but that shouldn't matter
6. links from copying from source are nonexistent (this is a good thing - we don't want that)
In short, how can we fix the upper section to capture the data from the lower section so stats show properly?? Hopefully, you can see what I'm talking about below...
Thanks in advance for your expert knowledge!
Debbie
1. The sheet was protected (so the user cannot manipulate the formulas). Unprotected here for editing purposes
2. One cell referenced an incorrect cell (this has been since fixed)
3. When copying the new range to other workbooks/worksheets, the referenced data captures correctly for a split second, then shows all "0's" (range a15:I15 - a3010:i3010)
4. Rows 1:12 do not update when copying new (but same) info to new sheet, BUT, if one MANUALLY enters data, the stats for each pitcher is updated. (same thing happens when copying data Row 12:3010)
5. I've seen a formula error (cells referencing empty cells), but that shouldn't matter
6. links from copying from source are nonexistent (this is a good thing - we don't want that)
In short, how can we fix the upper section to capture the data from the lower section so stats show properly?? Hopefully, you can see what I'm talking about below...
Thanks in advance for your expert knowledge!
Debbie
| Pitch Chart update 4-27-22.xlsx | |||
|---|---|---|---|
| G | |||
| 7 | 0 | ||
Game1 | |||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| G7 | G7 | =IFERROR(COUNTIFS($B$15:$B$3010,"*Dismukes",$F$15:$F$3010,"Y",$H$15:$H$3010,"C*"),0) |
| Named Ranges | ||
|---|---|---|
| Name | Refers To | Cells |
| Strike | =Game1!$H$15:$H$480 | G7 |
