modified code merge duplicate items for each sheet separately based on this thread

[KalilMe]

hi
actually I search for macro like in this thread https://www.excelforum.com/excel-pro...eparately.html based on post #3 , but the result should show in sheets(report,import,export) not like the orginal thread result1,2,3

this the code

I hope woner's code or any body has knowladge in vba to mod this code
thanks in advance

[jindon]

Please Login or Register  to view this content.

[KalilMe]

fantastic ! just last thing can I delete columns C,D(CLIENT NUMBER,CUSTOMER NUMBER)? I don't want them in sheets (report,import,export) after run the code
see my file ,please and sorry I don't ask so from the beginning

[jindon]

Upload a workbook with EXACT result that you want with the EXACT sheet names.

[KalilMe]

I really did . did you see my file?
the only different thing in file post#3 there is no columns (CLIENT NUMBER , INVOICE NUMBER) in sheets(report,import, export) after run the code . that's all of what I want it .it should ignore theses columns when show the result in sheets (report,import, export) if this is not clear I really no know what I have to do to understand me .

[jindon]

I hate how you ask question and now you are asking different question.

This is my last post to your thread.

Please Login or Register  to view this content.

[KalilMe]

you are asking different question

I admited for you . this is not based on my OP . if this is disturb you . you can refuse . nobody enforce you what you to do .
anyway your last code it gives error . so it's the last your post
in this thread as you said . I have to thank you for your solution based on my OP.
thanks very much for your assistance and time