• 1. Convert Numbers to Text (NPR) This VBA Code is basically the amended version of code that converts the Number to Text in NPR Currency. This gives us a function to us for getting the text related to the number.
• 2. Separate Tables into Sheets based on a Column There are times when we need to filter and separte the table into sheets based on columns like branches or departments. This will automate that work.
• 3. Separate Worksheets into Separate WorkBooks Once the sheet is separated into different worksheets (as given in example 2), many times we need to send different sheets to different people (vendors/branches/departments). This process will make that part easy.