I have two lists on Sheet"RawDataBher". 1st list is from column AL to column AO, 2nd List is from Column AR to Column AV.
I need a VBA code, which should compare 1st list 1st two columns(i.e AL & AM) with 2nd list 1st two columns(i.e AR & AS).
if it finds same data on both lists, it should paste them and their value present in column AT & AU at column AZ & BA, other wise it should return zero if first list data is not found at 2nd list.
Attached is sample sheet
You can do it with a VLOOKUP formula.
Copy the list AL:AM to AX:AY
Put these formula in AZ3 and BA3 and copy down the list
AZ3
Formula:
Please Login or Register to view this content.
BA3
Formula:Please Login or Register to view this content.
Or you could use the existing list in AL:AM and put the formulas in AP:AQ
Last edited by AlphaFrog; 03-22-2020 at 07:07 AM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Great and thank you dear... But i need to automate the process just on one click because this data is coming from other sheets and it is linked with main database, so i need a VBA code which should copy the two columns as you suggested and then perform the operation as you did by VLOOKUP. please help me with this
See if this can do
Kind regards
Please Login or Register to view this content.
Leo
Yes this is working great..thank you @LeoTaxi ....much appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks