Kindly see the attachments
And one more thing my data is big so in sheet 2 there r 4 Pasted parts so what i want is don't paste the data in sheet2 and paste that data in sheet4 (1st part)separately in sheet5( 2nd part)separately in sheet6 (3rd part) seperately and in sheet 7 (4th part)seperately
Link to download the sample file
https://www.ozgrid.com/forum/forum/.../1198481-copy-and-paste-data-as-per-condition
And one more thing my data is big so in sheet 2 there r 4 Pasted parts so what i want is don't paste the data in sheet2 and paste that data in sheet4 (1st part)separately in sheet5( 2nd part)separately in sheet6 (3rd part) seperately and in sheet 7 (4th part)seperately
Link to download the sample file
https://www.ozgrid.com/forum/forum/.../1198481-copy-and-paste-data-as-per-condition
