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.
Any help will be helpful.
Thanks.