Dazzawm
Well-known Member
- Joined
- Jan 24, 2011
- Messages
- 3,751
- Office Version
- 365
- Platform
- Windows
I need a code that will open dozens of files within a folder in my desktop and if what is found in column A in the active sheet in column AG in each file then it needs to be changed to what is in column B as below. Thanks
Excel 2010
<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Excel 2010
A | B | |
---|---|---|
1 | Column AG | Changes To |
2 | Centre | Centre |
3 | Centre-LH | LH Centre |
4 | Centre-RH | RH Centre |
5 | FR | FR |
6 | FR Inner-LH | FR LH Inner |
7 | FR Inner-RH | FR RH Inner |
8 | FR Lower-LH | FR LH Lower |
9 | FR Lower-RH | FR RH Lower |
10 | FR Outer-LH | FR LH Outer |
11 | FR Outer-RH | FR RH Outer |
12 | FR Upper | FR Upper |
13 | FR Upper-LH | FR LH Upper |
14 | FR Upper-RH | FR RH Upper |
15 | FR-DS | FR DS |
16 | FR-Inner | FR Inner |
17 | FR-LH | FR LH |
18 | FR-Outer | FR Outer |
19 | FR-PS | FR PS |
20 | FR-RH | FR RH |
21 | Inner | Inner |
22 | Inner-LH | LH Inner |
23 | Inner-RH | RH Inner |
24 | LH | LH |
25 | Outer | Outer |
26 | Outer-LH | LH Outer |
27 | Outer-RH | RH Outer |
28 | RH | RH |
29 | RR | RR |
30 | RR Inner-LH | RR LH Inner |
31 | RR Inner-RH | RR RH Inner |
32 | RR LH+RH | RR LH+RH |
33 | RR-Inner | RR Inner |
34 | RR-LH | RR LH |
35 | RR-Outer | RR Outer |
36 | RR-RH | RR RH |
<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
So looking at row 3 if Centre-LH is found in column AG of any of the files then it needs to change it to LH Centre, save and close each file and so on...
Last edited: