C
Cincy
I have a spreadsheet with 32 worksheets, one worksheet for each NF
football team. For example, one worksheet is named Arizona, on
worksheet is named Atlanta, one worksheet is named Baltimore and on
worksheet is named Washington. I also have a summary worksheet where
reference a cell in each worksheet. In the summary worksheet, I hav
each team listed in a separate row in column A:
For example, Cell A2 says Arizona
For example, Cell A3 says Atlanta
For example, Cell A4 says Baltimore
For example, Cell A33 says Washington
In column B it references the same cell in each worksheet:
For example, Cell B2 says =Arizona!B20
For example, Cell B3 says =Atlanta!B20
For example, Cell B4 says =Baltimore!B20
For example, Cell B33 says =Washington!B20
Is there a way I can write one equation in cells B2 through B33 tha
works for all the cells. The name of the team worksheet is alread
listed in column A and I want the equation in column B to go to th
worksheet listed in column A and then return the contents of cell B20
football team. For example, one worksheet is named Arizona, on
worksheet is named Atlanta, one worksheet is named Baltimore and on
worksheet is named Washington. I also have a summary worksheet where
reference a cell in each worksheet. In the summary worksheet, I hav
each team listed in a separate row in column A:
For example, Cell A2 says Arizona
For example, Cell A3 says Atlanta
For example, Cell A4 says Baltimore
For example, Cell A33 says Washington
In column B it references the same cell in each worksheet:
For example, Cell B2 says =Arizona!B20
For example, Cell B3 says =Atlanta!B20
For example, Cell B4 says =Baltimore!B20
For example, Cell B33 says =Washington!B20
Is there a way I can write one equation in cells B2 through B33 tha
works for all the cells. The name of the team worksheet is alread
listed in column A and I want the equation in column B to go to th
worksheet listed in column A and then return the contents of cell B20