Conditionally copy paste the data

[dumdumbum]

Plz see the sample file
In sample file i have mentioned all the details
Its a copy paste of the data conditionally
I am looking for macro

[Mumps1]

Try:

Please Login or Register  to view this content.

Change the sheet names (in red) to suit your needs.

[dumdumbum]

Awesome Mumps
Thnx Alot Bro for ur Great Support
Problem Solved

[dumdumbum]

One more tip Bro
After runing the macro i need the changes to be saved can u help me for the same

[Mumps1]

What is the full path to the folder where you want to save the file? What file name would you like to use? Do you want to save it with or without the macro included.

[dumdumbum]

To the same path, location will be same,file name will be same

[Mumps1]

Try:

Please Login or Register  to view this content.

Please note that the file will overwrite any existing file with the same name. If you want to be prompted to overwrite any existing file, delete the 2 lines of code containing "DisplayAlerts".

[dumdumbum]

Awesome Mumps
Thnx Alot Bro for ur Great Support
Problem Solved

[Mumps1]

My pleasure.