Skip to main content

worksheet : TABLE_CREATE - Multiple Tables

Overview

This video extends the TABLE_CREATE demonstration by showing how to create multiple Excel tables within a single worksheet or across multiple worksheets. When working with complex automation workflows, engineers often need separate tables for different data sets — such as one table for part parameters and another for assembly data. The video demonstrates how to define multiple TABLE_CREATE commands, position tables to avoid overlapping, and manage multiple data structures within the same workbook. It also covers naming conventions and best practices for organizing multiple tables.

Key Steps

  1. Plan the layout for multiple tables to avoid overlapping cell ranges
  2. Enter multiple TABLE_CREATE commands with unique names and positions
  3. Execute the commands to create all tables in the workbook
  4. Verify each table was created with the correct structure and position
  5. Use the tables independently for different data population workflows

Tips

  • Leave sufficient space between tables to accommodate data growth
  • Use consistent naming conventions for tables to keep the workbook organized
  • Consider placing different tables on separate worksheets for clarity