Vba code to compare the 2 sheets and paste the values in 3rd sheet

[Abinaya]

Hi all,

I am very new to Excel macro. please help me to solve below macro.

I have a workbook with 2 sheets. Both the sheet contains Column "Name,Avg,Max". Compare both the sheets and paste the Avg values in Sheet3(Avg) and Sheet4(Max). I have attached the sample file below. Let me know if you need more explanation.

Anyone can help me to solve this?


Thanks,
Abinaya

[Miroslav R.]

Hi there,

take a look at attachement:
comparison.xlsm

Done with this code:

Please Login or Register  to view this content.

Hope it helps

[JOHN H. DAVIS]

You could use VLOOK-UPs for this.

[Abinaya]

Hi,

Thanks for your help.
this code helped me. but, still i want to do some more changes. if you explain this code in better way, it will be very helpfull for me to do changes. Could you be pls exaplain the code?

[Miroslav R.]

Hi there,
open attached file, and in VBA enviroment, You will find my commnets.
comparison.xlsm

If You still find something that is not clear for You, let me know, but try to debug first (click in 'Start' macro and hit F8 to debug line by line).

Hope it helps

[Abinaya]

Hi M.R,

Thanks for your comments. it helped me. Thank you for that
I need one more help from you. I did some changes in the result sheet. I merged the row 3&4 and named it as name of transactions. when i try to run the macro. i am getting error in the line

"aRow = AVGsht.Cells(3, 1).End(xlDown).Row + 1"

Could you pls help me to solve this?

[Miroslav R.]

Hi there,
slightly modified... I merged also the header in 'Maximum' sheet and now it should work as You required:
comparison.xlsm

Test and let me know

[Abinaya]

Hi M.R,
Thank You Very much. I have tested the Code which you gave last week. It was working Well. Thank you so much for helping me.

[Miroslav R.]

You are welcome!

send from my xperia z via tapatalk