title: Creating macros with given condition, adding sheets
body: <p><a href="https://i.stack.imgur.com/uPtLC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uPtLC.png" alt="Sample Data"></a></p>
  
  <p>Hi all, I need help with the following table. I have customer names in column J. Now I need to create new sheet with each customer name and copy all the related rows and columns with header for this particular customer. Also, as you can see under Customer_name, there are numbers or codes attached at the end. So i need to create new sheets(containing all the information about that customer) with following customer names as per given sample table
  Sheet 1 - VCLD- 1610
  Sheet 2 - VCLD- 1660
  Sheet 3 - BVM 3002003
  Sheet 4 - 30  (This sheet contains all the customers with codes starting with 30, i.e 30-32003,32090)
  Sheet 5 - 30-32003
  Sheet 6 - 30-32090</p>
  
  <p>Can somebody help me out here, how to do it, using functions or macros. Please help. Thank you!</p>