Help! Automate Objects that links to Data Table

[gelotangson]

Please help me to automate the objects linking to a data table. I have the workbook attached and inside are the questions.

[BadlySpelledBuoy]

Automate what exactly? I'm not sure what the ask is here.

BSB

[gelotangson]

how to create macro in an object that links into specific cell

[BadlySpelledBuoy]

What object??
You're going to need to provide much more information if you want help on this.

BSB

[MSDols]

Hi gelotangson,
try to break it down step by step. For example:
1. I click on the object "Rectagle 18" (blue) in the "PDM" sheet. The "Data" sheet opens.
2. I click on any filled row in the "Data" sheet.
The data from the selected row is transferred to the objects in the "PDM" sheet.
Then sum "Rectagle 17" + "Rectagle 13". The result is saved in the object "Rectagle 11".
3. ...
m.s.
sum