Date issue in macro recording

[earthworm]

If there are two dates column and both the headers of date column is named as 'Date' . I have observed that when i extract the data through advance filter the date value of both column appears correctly i.e values of both column my differ . however when i apply the same working through macro the macro replace the date of second column with 1st date column . i think its the bug . due to to which i have to change the name of 2nd column of date as XYZ date in order for macro not to replace the date value with first column. please assist.

 

[Joe4]

Please post the macro code.