Table to Table reference

[gerasimos]

Hi all

What I am trying to do is that I'd like to reference a single cell in a table, from outside the table, using square-bracket sheet-formula notation. If this can be done with VBA or Macro I am fine with that. I can make it work with PC but something wrong with MAC. I think that vba will help.

This will do the job for Windows but not working for MAC. I press refresh and alll, can this be done with VBA?

=Invoice[@[PCS]:[PCS]]

SampleFile

Thank you !

 

[RoryA]

As you should be aware:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Structure Reference weird - OzGrid Free Excel/VBA Help Forum

Hello all, I have a simple excel that has two sheets. One FORM and second RATE Both have Tables. My need is, when the table in sheet FORM fills then automatically fill and the table at sheet RATE I am trying to make it happen but #Value keeps coming. I…

forum.ozgrid.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[gerasimos]

Yes you are correct. I didnt get an answer to ozgrid and tried another forum (mrexcel). I didnt know how to close the thread to ozgrid.
Is that ok?

Structure Reference weird - OzGrid Free Excel/VBA Help Forum

And for some reason (multiple account at the same pc) I used my brothers account.

So is it possible to help me with that?

Thank you

 

[RoryA]

I don't understand your logic. (And FYI, your formula will not work on Windows either because the tables occupy different rows)

Based on the presence of an Item column in both tables, it looks like you probably want a lookup of some sort rather than a straight formula link.

 

[gerasimos]

My logic is that I have a table in Sheet FORM that it is filled with data. I want data are ented then transfered (mirror) to Sheet RATE, automatically
Basically I interesting for Item ,PCS, Price
Detailed

FORM(ITEM) ---> RATE(ITEM)
FORM(PCS) ---> RATE(ΤΕΜΑΧΙΑ or ITEM)
FORM(PRICE) --- RATE(PRICE)

the other at RATE sheet are to calculate.

I really hope you understand. I am using TABLES (Form table INVOICE, RATE table RATE) to be able to increase rows etc

Thank you !

 

[RoryA]

You will need code for that, but what is the point in duplicating the data?

 

[pantakos]

1

 

[gerasimos]

To use them for calculations

 

[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