< All Bots

Split Data in Same Workbook

Bot extract data from input file and with the help of macro file it create sheets with name of agent and fill the data according to agent into each sheet.

Top Benefits

  • No Human intervention required
  • Its fast to create multiple file with each agent and its accurate.
  • Its works dynamically and big time saver.

Tasks

  • Extract data from input file
  • Split data into multiple sheet as per agent
  • create output file and give very quick required output.

Bot extract data from input file and with the help of macro file it create sheets with name of agent and fill the data according to agent into each sheet. No need to open file and split data manually its totally works dynamically. You can schedule your bot and its all done !!!.

Get Bot

Free

Applications
Business Process
Category
Security
Passed third-party anti-virus scan conducted by Automation Anywhere.
Downloads
15
Vendor
Automation Type
Bot
Last Updated
November 18, 2019
First Published
November 18, 2019
Enterprise Version
10.7
Community Version
Not Supported
ReadMe
ReadMe
Support

See the Bot in Action

Input file with data
Output file with Split Data in yellow highlighted tab.
Split Code with using of macro file.
PREV NEXT
Input file with data
Output file with Split Data in yellow highlighted tab.
Split Code with using of macro file.

Setup Process

Install

Download the Bot and follow the instructions to install it in your AAE Control Room.

Configure

Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)

Run

That's it - now the Bot is ready to get going!

Requirements and Inputs

  • InputDataFile.xlsx
  • MacroFile.xlsb
  • Automation Anywhere must Installed
  • MS Excel 2003 or higher