Hi there !
first of all, sorry if the question was already asked I did not find any suitable answer
here is my problem. I have one table called Salesplan that have 26+fields. among thoses fields are planning for prodution for the 12 month of year and fields for the real producion for the same 12 months. in other words I have
Salesplan.pl_m1 , salesplan.pl_m2 , salesplan.pl_m… , salesplan.pl_m12 , salesplan.re_m1, …, salesplan.re_m12
my goal is to fill a table of 2 rows and 12 columns with one loop(on the column) and
table.cell(1,col).data( #some kind of expression I can build to get my 12 planned month fields#)
and table.cell(2,col).data( #some kind of expression I can build to get my 12 realized month fields#)
in other word is this some kind of function (like the =indirect("") in excell )that allow my to define dynamicaly the field or th table I want to read the data from ?
thank you very much in advance.