move data to new worksheet based on criteria vba

In the attached file from Column A wherever i have the text as "Customer copy"  for each of the ""Customer copy" the data have to be copy pasted to a new sheet
sample.xlsx
NirvanamanagerAsked:
Who is Participating?
 
als315Connect With a Mentor Commented:
Test this sample (allow macros and press button)
sample--split-to-worksheets-.xlsm
1
 
NirvanamanagerAuthor Commented:
just brilliant . Thanks a ton mate
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.