Changing the name of a table reference

[Noah_GeorgeANSVN]

I'm trying to create a template where I link data from different tables into 1 main table. However, there doesn't appear to be a straight forwards way to do this. When I go to insert a formula into the main table I can only link 1 cell and not add multiple ones together to get a total. I've also tried referencing the name of the table as part of the formula but they are all identified generically, i.e. Table(226475846663952). Is there a way to change this reference to something more specific like 'Table 1'. 

Any advice would be appreciated thanks.

[Brock_Olly · Accepted solution]

You can use the formula > sum option, this works similar to excel but creates a field that references the other table (using its table number, this number cannot be changed as it's the objectID number autocad assigns to it)

You can get tableID numbers by typing FIELD, going to Objects, Object, then select the table with the pick box. The ID number is displayed in the 'field expression' after 'ObjId'

As far as I know you can't change the ID names, maybe with VBA code?

Personally I create all my tables in excel and only paste them in autocad when needed.

[pendean]

Why not create tables in Excel, 100% of the time with all of those pro tools in the program, then just olelink or paste into autoCAD?