Clone entire sheet. Clone specific area in a given range. Clone the specified sheet name provided.
The formula is used to count columns of a specific range VBscript is used to copy sheet, add a sheet, add a sheet with the same name
See the Bot in Action
Download the Bot and follow the instructions to install it in your AAE Control Room.
Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)
That's it - now the Bot is ready to get going!
Requirements and Inputs
- Notepad(VBscript), provided with one sample input file you can use any excel file and change the input file path in the config file and output file should be already created
Inputs: To clone the entire file : Input file Output path To clone a specific area: Input file Output file Sheet name Firstcellvalue Secondcellvalue To clone a specific sheet: Input file Output file Sheet name