XXXXXXX
year Period Week Widgets Finished
2011 1 1 1374932 1404454
2011 1 2 1682296 1721592
2011 1 3 1756761 1833206
2011 1 4 1572590 1612353
2011 2 5 1612296 1687144
2011 2 6 1457374 1571107
2011 2 7 1498288 1565851
I want the Period to show up in the XXXXXX cell no matter where...
what if I want the "INDIRECT" cell to be recognized in another column? IE: a different query is looking at the cells with INDIRECT reference and doesn't recognize the cell
We have a formula $W$2 and want it to go down the row as $W$2,$W$3,$W$4,$W$5,$W$6
but can't get it to copy.
Manually changing is not an option since we have over 60000 records.
Any help would be appreciated.