Search results

The Code which you provide showing some error. I copied and paste it on file. But showing errors. It is not working. Also please tell me it shows all duplicate items as you mentioned on the previous answer regarding Hercules Sparx 2.0 RF 24" Black . Please can you provide file with code. a...

I want every occurrence of the duplicated item with row number, date, quantity. If this code provide the result like that.

Thanks for all the help you provide regarding this question. As per the report , we mentioned Date, Item , Quantity for each reports, ie Missing Values in Sheet2, Duplicate Value in Sheet1, Duplicate values in Sheet2. Can we show Date and Item for each report in report sheet if there is...

Thankyou for reply and help. 1st The code which you given not working, I download the attached file which is working but duplicates value of both sheet1 and Sheet2 comes together. Also Date columns of Duplicate value comes between missing items Column A. I would like to have the report as the...

Thanks for your reply and help. We need to get missing values based on Sheet1, ie Data in shee1 but not in Sheet2, and duplicate from both Sheets Output is same as in result sheet (See Result) in single sheet with Date , item quantity (A,B,C ) column ie Missing Value in Sheet2, Duplicate Values...

Thank you for your kind help and tutorial link you you given. I checked that link and very helpful. The given VBA, did it compare B and C column ie. Item and quantity. If sheet1 Item and Quantity is matching Sheet2 that is not Duplicate. That item may differ. If we want to compare with...

I would like to compare two sheets and copy result to another sheet as per the attached file with the help of macro. Hoping your help regarding this matter. thanks for every previous help.

Thanks a lot for your kind help. I tested the above code in my orginal file with 400 rows , day before yesterday then I noticed that all records not copiping. Some rocords are missing. What will be the reason Kindly please check . Thanks in advance

Can I ask only one more question , If I want to change the range D3:F for both files then how to change the macro. Thank you so much for your kind help.

Once we run the Macro and copy the missing data then again we run the macro it shows error in the following line missing_data.Copy

Thanks for your kind help, I want one more help My both file at H:\New folder (2)\New folder I try to change the path but showing error How to change the path

I have 2 Excel file and I want to update ZYZ file with ABC file missing item with its related date and quantity from one file to another. I have a macro which copy only item field. I have to update missing item with its related columns (A, and C)