• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. C

    Way to dynamically address a structured reference

    I was playing with this too and I came up with the same answer, as long as you use the column number rather than the [FIELDNAME] this does work. Now I can put the FIELDNAME in dropbox and let the user define the "field" they want to see thanks
  2. C

    Way to dynamically address a structured reference

    Download link: http://speedy.sh/gfRRM/ChandooEx1.xlsx What I am trying to do is in the file. THe "TABLE" is from a SQLSVR download. Yellow columns are entered by user. Database to be refreshed upon entry of yellow fields, Then I want them to be able to fill in CELL "C22" with any...
  3. C

    Way to dynamically address a structured reference

    I have one, but I am not sure how to upload it...
  4. C

    Way to dynamically address a structured reference

    Is there a way to tie a structured reference to a cell? Example I have a table with 20 columns. 1=SID 2=DG1_PLAN 3=DG1_ACT 4=DG2_PLAN 5=DG2_ACT 6 7 etc I know this address works: =Table[[#DATA],[DG1_PLN]] meaning the data table ="TABLE", column="DG1_PLN" BUT I want to "tie"...
Back
Top