Find and Copy

[Jose Miguel]

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

 

[Barrie Davidson]

What about just using a SUMIF? Something like:

=SUMIF(C1:C1000,"TOTAL E-COM",D1:D1000)

 

[Jose Miguel]

Oh my goodness, I forgot all about this. So simple! Thanks!

Jose