Author Topic: Copy a field from one table cell to another table cell  (Read 774 times)

0 Members and 1 Guest are viewing this topic.

nini007

  • Newt
  • Posts: 55
Copy a field from one table cell to another table cell
« on: October 12, 2022, 10:36:08 AM »
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

  • Gator
  • Posts: 2829
  • Marko Ribar, architect
Re: Copy a field from one table cell to another table cell
« Reply #1 on: October 12, 2022, 11:03:01 AM »
Is this what you wanted?

HTH., M.R.
Marko Ribar, d.i.a. (graduated engineer of architecture)

:)

M.R. on Youtube

nini007

  • Newt
  • Posts: 55
Re: Copy a field from one table cell to another table cell
« Reply #2 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

ribarm

  • Gator
  • Posts: 2829
  • Marko Ribar, architect
Re: Copy a field from one table cell to another table cell
« Reply #3 on: October 13, 2022, 12:34:46 AM »
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

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...
Marko Ribar, d.i.a. (graduated engineer of architecture)

:)

M.R. on Youtube

nini007

  • Newt
  • Posts: 55
Re: Copy a field from one table cell to another table cell
« Reply #4 on: October 14, 2022, 10:49:15 AM »
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

ribarm

  • Gator
  • Posts: 2829
  • Marko Ribar, architect
Re: Copy a field from one table cell to another table cell
« Reply #5 on: October 14, 2022, 11:39:33 AM »
Not sure, have you tried TABLEEXPORT command... As for opposite, I have this old *.vlx downloaded from cadforum site... I hope author won't mind posting it...

M.R.
Marko Ribar, d.i.a. (graduated engineer of architecture)

:)

M.R. on Youtube

nini007

  • Newt
  • Posts: 55
Re: Copy a field from one table cell to another table cell
« Reply #6 on: October 17, 2022, 03:14:12 PM »
Hello,
I thank you for your message.
Indeed I went looked on the CAD Studio site and indeed I found Tab2Xls.VLX which allows to export an AutoCAD table to Excel but unfortunately only one at a time.
It would have been handy to take a capture of all the tables and export each table to a different tab of an excel file, but that may not be possible.

Thank you for your help

Best regards