# Macro or Command?

#### cgreen

##### Active Member
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
Libro1
ABCDEFG
1Team1TotalwinsTotalpenaltiesTeam2TotalwinsTotalpenalties
2Week151Week160
3Week230Week213
4Week382Week325
5
6
7
8Week2
9TotalwinsTotalpenalties
10Team130
11Team213
Hoja1

#### paliman

##### Active Member
Libro1
ABCDEFG
1Team1TotalwinsTotalpenaltiesTeam2TotalwinsTotalpenalties
2Week151Week160
3Week230Week213
4Week382Week325
5
6
7
8Week2
9TotalwinsTotalpenalties
10Team130
11Team213
Hoja1

#### cgreen

##### Active Member
Thank you ... it worked great.

Replies
0
Views
107
Replies
0
Views
90
Replies
2
Views
156
Replies
8
Views
296
Replies
6
Views
153

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.

### Which adblocker are you using?

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

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