Jose Miguel
Board Regular
- Joined
- Feb 3, 2005
- Messages
- 99
Hello All,
I want to be able to have a code that will search for text, recognize the cell beside it, and eventually sum these totals.
In particular, to find the each occurence of the text Total-Ecom, and copy the cell beside it, and total each occurence at the bottom of the spreadsheet. Thanks everyone for your help.
Jose
I want to be able to have a code that will search for text, recognize the cell beside it, and eventually sum these totals.
ElectronicCommerceAndLines_IA-SAM-055(1).xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
4 | INTERNET | 157 | 1 | |||||
5 | FTP | 0 | 0 | |||||
6 | B2B STATIC | 0 | 0 | |||||
7 | OBI | 0 | 0 | |||||
8 | B2B INTEGRATION | 0 | 0 | |||||
9 | LABSHOP | 0 | 0 | |||||
10 | STOCKTRACKER | 0 | 0 | |||||
11 | VISTANT | 0 | 0 | |||||
12 | TOTAL E-COM | 157 | 1 | |||||
13 | TOTAL | 13,178 | 64 | |||||
14 | % E-COM | 1.2 | 1.6 | |||||
15 | EDI | 0 | 0 | |||||
16 | INTERNET | 253 | 6 | |||||
17 | FTP | 0 | 0 | |||||
18 | B2B STATIC | 0 | 0 | |||||
19 | OBI | 0 | 0 | |||||
20 | B2B INTEGRATION | 0 | 0 | |||||
21 | LABSHOP | 0 | 0 | |||||
22 | STOCKTRACKER | 0 | 0 | |||||
23 | VISTANT | 0 | 0 | |||||
24 | TOTAL E-COM | 253 | 6 | |||||
Sheet1 |
In particular, to find the each occurence of the text Total-Ecom, and copy the cell beside it, and total each occurence at the bottom of the spreadsheet. Thanks everyone for your help.
Jose