VBA Code to compare data between 2 sheets and copy differences

[shafiq2]

Hi,

I have a master list of Date in Column B and Ex.Rate in column A "Sheet1", and another sheet called "Sheet2" this sheet gets updated with new Date and ex.range, I want a VBA code to compare this two list and add the differences in new row from sheet2 to sheet1 same range.

Kind Regards,

 

[shafiq2]

Hi,

Here is the code as you requested.

[Range("A2:B19").Select
Selection.Copy
Sheets("SHEETNAME").Select
Range("A" & Rows.Count).End(xlUp).Offset(1).Select
ActiveSheet.Paste
ActiveWindow.SmallScroll Down:=3
Range("B118").Select
Application.CutCopyMode = False
ActiveSheet.Range("$A$1:$B$151").RemoveDuplicates Columns:=2, Header:=xlYes]

 

[hiker95]

shafiq2,

Thanks for the macro code.

Using the VBA Editor to record your movements in the workbook will get the job done to a certain degree.

Glad you were able to solve your own request.

And, come back anytime.