Lookup string, find in another workbook, set value to offset of found location

    Hi all -


    I need to do the following:


    1)Record value from cell B2 as a variable
    2)Find this variable in another workbook
    3)Set values to cells located in offset positions to the found cell


    Thanks,
    Chris

    Re: Lookup string, find in another workbook, set value to offset of found location


    Nothing out of the way, or unusual, there. About the only complication is you need to check that value was found before getting the offset value


    What problem do you have with it?

    Re: Lookup string, find in another workbook, set value to offset of found location


    I do not know how to do it. I am a macro recording googling noob. Can you give me some generic code to do this that i can start with?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login