Cut & paste between sheets

Should it now be a new file or a new sheet? You can use the advanced filter as a basis. Make sure that the column headings are complete.

Please Login or Register  to view this content.

I reuploaded the sample file plz see Sir & Sorry for the same

Please Login or Register  to view this content.

I modified the code as per my needs
but code is missing column I ,column J data & column K data & i need that data also plz run the macro & see

See the note in # 2

Make sure that the column headings are complete.

Sir may be heading will be there or there should be chance it is not there

So plz help me in making this macro workable

What should we do with the link and what doesn't work? You are not very informative.

Sorry Vraag en antwoord Sir
But Sir i need all data along with column I ,column J data & column K data but the above macro is not pasting the data bcoz it doesn't have headers Sir
So i am looking for the solution Sir
It will be a Great Help if u help me in solving this Problem Sir

I already gave the solution. If you don't understand it, you better not use macros.

Thnx Alot Vraag en antwoord Sir for ur Great Suggestion
give me some time

Sorry Vraag en antwoord Sir
But there will not be header in that column
So plz modify it so that it can work on that also Sir

Seems to me something you can easily solve yourself.

Sir I am unable to solve this problem Sir
I thought I can do it
But I was unable to do so
That's y I am looking for help Sir

What doesn't work then? You can still add the column headings manually or via the macro.

Sure Sir i will do it manually
Thnx Alot Vraag en antwoord Sir for helping me in solving this Problem Sir
Problem Solved
Have a Awesome Day Sir