CAD Forums > CAD Standards

Copy a field from one table cell to another table cell

(1/2) > >>

nini007:
Hello forum,

I need you 🙂.
I will try to keep it simple.
Attached is an autocad file with 4 surface charts for colors, red, green, blue and yellow.
I have a Recap table and in this table I would like to retrieve the total of the 4 tables, I tried with copy/paste it does not work.

PS: the 4 color tables evolve (deletion, addition, modification, etc.)

In fact I would like to automate the updating of tables.

Is it possible ?

Thank you in advance for your help.
Best regards

ribarm:
Is this what you wanted?

HTH., M.R.

nini007:
Hello,

Yes congratulations, that's exactly it  :yes:
How did you find the table ID ?

And is it possible to automate? Let me explain, if I add/delete a line in the "Red" table, that the totals are calculated automatically without having to change the formulas each time ?

Thanks in advance
Best regards

ribarm:

--- Quote from: nini007 on October 12, 2022, 03:26:49 PM ---Hello,

Yes congratulations, that's exactly it  :yes:
How did you find the table ID ?

And is it possible to automate? Let me explain, if I add/delete a line in the "Red" table, that the totals are calculated automatically without having to change the formulas each time ?

Thanks in advance
Best regards

--- End quote ---

It should be automatic, but from my perspective, still, I'd avoid erasing cell value and instead just leave 0.0, so final result would be correct... Not sure, but I suppose it would be so and if you delete...

Now how did I do it :
Very simple ... You enter cell you pointed with arrow, right click and choose field option and when dialog box pops up, you go to "Objects", then "Formula" and first thing you should do is click on button "Cell" - that is in line along with (Average, Sum, Count, Cell), then you point to cell from table you wish and that's it... The rest is assigning multiplication factor and choosing removing trailing/leading (I've chosen trailing) zeros...

nini007:
Hello,

Thank you for your message and your help.

A small question, is it possible to export all the tables in Excel format at once ?

Thanks in advance
Best regards

Navigation

[0] Message Index

[#] Next page