Macro or Command?

cgreen

Active Member
Joined
Aug 14, 2002
Messages
291
I have 14 tabs (one for each team). There is 26 weeks of play. On each teams tab I have week 1, week 2, week 3, etc. in column ‘A’. Column ‘B’ has total wins and column ‘C’ has total penalties (all of the teams’ tabs are set up the same way).
Example:
A2 = week 1 (1)
B2 = week wins (5)
C2 = week penalties (1)

A9 = week 2 (2)
B2 = week wins (3)
C2 = week penalties (0)

A16 = week 3 (3)
B16 = week wins (8)
C16 = week penalties (2)

This goes on until the last entry

A177 = week 26 (26)
B177 = week wins (2)
C177 = week penalties (0)

I have a main tab that brings over totals from other columns for each team. On ‘U1’, of the main tab, I enter what week we are in (1, 2,…. 26). On my main tab, when I enter the week number, I want it to grab the information from each teams tab for the corresponding week. The information I want is the ‘week wins’ and ‘week penalties’ from each teams tab to show on my main tab.
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

paliman

Active Member
Joined
Jul 7, 2002
Messages
254
Libro1
ABCDEFG
1Team1TotalwinsTotalpenaltiesTeam2TotalwinsTotalpenalties
2Week151Week160
3Week230Week213
4Week382Week325
5
6
7
8Week2
9TotalwinsTotalpenalties
10Team130
11Team213
Hoja1
 

paliman

Active Member
Joined
Jul 7, 2002
Messages
254
Libro1
ABCDEFG
1Team1TotalwinsTotalpenaltiesTeam2TotalwinsTotalpenalties
2Week151Week160
3Week230Week213
4Week382Week325
5
6
7
8Week2
9TotalwinsTotalpenalties
10Team130
11Team213
Hoja1
 

Forum statistics

Threads
1,147,499
Messages
5,741,506
Members
423,663
Latest member
kaveh87rsh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top