# 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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

#### 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
104
Replies
9
Views
220
Replies
4
Views
118
Replies
5
Views
77
Replies
6
Views
431

1,181,091
Messages
5,928,032
Members
436,583
Latest member
AlxBtx

### 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