bluefeather8989
Active Member
- Joined
- Nov 20, 2009
- Messages
- 325
- Office Version
- 365
- Platform
- Windows
Need vba to select first cell with same value as another cell
If M5 input is Wednesday then marco will find the first cell in range C:C that containes wednesday.
If M5 input is Wednesday then marco will find the first cell in range C:C that containes wednesday.
TV Shows.xlsm | |||
---|---|---|---|
C | |||
3 | Saturday | ||
4 | Sunday | ||
5 | Sunday | ||
6 | Sunday | ||
7 | Sunday | ||
8 | Monday | ||
9 | Monday | ||
10 | Monday | ||
11 | Monday | ||
12 | Monday | ||
13 | Monday | ||
14 | Monday | ||
15 | Tuesday | ||
16 | Tuesday | ||
17 | Tuesday | ||
18 | Tuesday | ||
19 | Tuesday | ||
20 | Tuesday | ||
21 | Wednesday | ||
22 | Wednesday | ||
23 | Wednesday | ||
24 | Wednesday | ||
25 | Wednesday | ||
26 | Wednesday | ||
27 | Wednesday | ||
28 | Thursday | ||
29 | Thursday | ||
30 | Thursday | ||
31 | Thursday | ||
32 | Thursday | ||
33 | Thursday | ||
34 | Thursday | ||
35 | Friday | ||
36 | Friday | ||
37 | Friday | ||
38 | Friday | ||
List |
TV Shows.xlsm | |||
---|---|---|---|
M | |||
5 | Saturday | ||
List |