Results 1 to 28 of 28

How to Search/Find Text and add values in corresponding columns

Threaded View

  1. #1
    Registered User
    Join Date
    05-30-2012
    Location
    Houston,Texas
    MS-Off Ver
    Excel 2007
    Posts
    24

    How to Search/Find Text and add values in corresponding columns

    Hi everyone i need help creating a marco that will first search throught the worksheet and find like "ACT" and then will search under "ACT" for the "Data" and then for every "data" it will add the vaules in column F and divide by 64 and put answer on a differnt work sheet. A EX.

    A ----------------F
    Act
    Data---------------1
    Data---------------2
    Data---------------3
    Act
    Data---------------7
    Data---------------2

    and will keep looping this till the last "Act" was found and "data" where add and divided.

    Thank you,

    Excelmanineedhelp
    Last edited by Excelmanineedhelp; 05-30-2012 at 10:07 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1