Hi I have list of items on sheet1 with an item name in range A and values in Range K, then on sheet 2 rage A I have a short list of the same items that changes on a regularly bases and values in range F. What I need is a code so that I can update the values in sheet2 range F, accordingly the list in sheet1 range A and range K. see also sheet attached. Thanks Jaco
Hello,
where does VBA come in? Why post in the VBA forum?
Where does loop come in? What loops?
Maybe I don't understand what you are trying to accomplish, but as far as I understand your description, you want a plain, vanilla Vlookup formula in Sheet 2. Starting in cell F3 and copy down:
If that does not help, please post more context.
Please Login or Register to view this content.
cheers, teylyn
Hi Telyn I'll try to explain. I'm busy with excel Vba and need a code to runs a module. What the code needs to do is to update the values in sheet 2 range F from sheet 1 range K that changes regularly. The code needs to find the values that tied up sheet 2 range A with sheet 1 range A and then goes across to range K find the value and replace the current "old" values in sheet 2 range F. Thanks for helping. Kind Regards. Jaco
Hi,
try the Vlookup formula I posted.
If it does not work for you, please explain what you need differently.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks