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
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,120
Messages
5,857,500
Members
431,882
Latest member
saaaaaaaaaaaaaaaaaaaaaa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top