# 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

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

#### 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
6
Views
76
Replies
2
Views
42
Replies
7
Views
75
Replies
0
Views
107
Replies
4
Views
136

1,147,745
Messages
5,742,954
Members
423,767
Latest member
dafydd_jwc

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