Hi All,
Basically as the title says I need a VBA Macro to Lookup values in one cell, if they match copy content of another cell to different sheet.
Basically I will have a sheet (Will be more in depth) that will list names & credits what I need is a macro that checks if the "Agent Name" is on the "Agent" Sheet if it is then I would like it to copy the value from the "Credit" cell next to the name I have uploaded an en example.
Thanks
I am not able to understand your question at all. Please explain with the help of the sheet.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi,
Sorry about that basically I would like a macro button on the "Credit" tab which checks the cells in A1:A200 to see if the name is on the "Agent" Sheet if it is I would like it to copy the contents from the cell "CREDIT" on the "Agent" sheet and paste it next to the agent's name on the "Credit" Sheet if possible please.
Thanks
I was told I am to use something like
=IF(VLOOKUP(A1, Agent!A$2:I$26,1)=A1,VLOOKUP(A1, Agent!A$2:I$26,4),"No match")
But that's not working correctly
Last edited by ezay; 07-31-2012 at 04:00 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks