Find and Copy

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.
ElectronicCommerceAndLines_IA-SAM-055(1).xls
ABCDEF
4INTERNET1571
5FTP00
6B2B STATIC00
7OBI00
8B2B INTEGRATION00
9LABSHOP00
10STOCKTRACKER00
11VISTANT00
12TOTAL E-COM1571
13TOTAL13,17864
14% E-COM1.21.6
15EDI00
16INTERNET2536
17FTP00
18B2B STATIC00
19OBI00
20B2B INTEGRATION00
21LABSHOP00
22STOCKTRACKER00
23VISTANT00
24TOTAL E-COM2536
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
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Watch MrExcel Video

Forum statistics

Threads
1,118,763
Messages
5,574,096
Members
412,567
Latest member
mm1
Top