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
Bookmarks