Loop through a column if a cell contains a specific text return value

[adrix]

Hi, I have one worksheet with a lot of data and I need to copy just the numerical values of the "total" cells in another sheet. I was thinking and I thought it was a good idea to create a loop that searches the word "total" in all the column and return me the numerical value of it each time the loop finds the "total". The numerical value is 7 columns far from the "total" cell so I try to write it with the function OFFSET.
Any help will be helpful.
Thanks.

 

[Joe4]

Welcome to the Board!

Since you are using Excel 365, have you given thought to using the new FILTER function?

FILTER Function

The Excel FILTER function is used to extract matching values from data based on one or more conditions. The output from FILTER is dynamic. If source data or criteria change, FILTER will return a new set of results. This makes FILTER a flexible way to isolate and inspect data without altering the...

exceljet.net

It would return all the columns, but you could simply hide the ones you do not want to see.