Hi
one way in VBA

dim return_value
return_value=application.vlookup("Total",range("G: H"),2,0)
msgbox return_value

--
Regards
Frank Kabel
Frankfurt, Germany
"Jeff" schrieb im Newsbeitrag
...
Total is always in column G and the value I need always in column H
Thanks,

"Frank Kabel" wrote:

Hi
is your 'Total' label always in column G?

--
Regards
Frank Kabel
Frankfurt, Germany

Jeff wrote:
Hello,

I need help designing a VBA Macro: I have in cell A1 "Paid" in cell G8
"total" in cell H8 $100.00

What I need is: to cell.find "paid" then to do cell.offset to G8 to
select.copy the value in H8. Is this possible ?
Regards,