Insert table1 from sheet1 to another table2 in sheet2

[gerasimos]

Hello all,

First I have made the same question to forums ozgrid (my brother) and mrexcel.

The situation is:

I have a table in Sheet1 that with VBA code collects data from other sheets.
I need the values from that table to be inserted in Table2 in another sheet in order to use that table2 for calculations. I only need the value of PCS
I tried [@PCS] etc but no luck.
The formulas are ready at Table2.
The very best will be this be done in VBA in order to fully work on MacOS

Please find attached the sample file

https://docs.google.com/spreadsheets...f=true&sd=true


If you can help I will appreciate!

Thank you in advance,
Gerasimos

[gerasimos]

Dear all I finally figured out how to do this, using PowerBuilder.

Thank you

PS I cant delete or close this post, so please admins to do that.

Gerasimos