Display specific values and columns macro code

  • Hello All


    I'm a new member... wanted some help on this project that I'm working on. I'll try to explain it as best as I can.


    So I've got this table
    [TABLE="class: grid, width: 500"]

    [tr]


    [td][/td]


    [td]

    A

    [/td]


    [td]

    B

    [/td]


    [td]

    C

    [/td]


    [td]

    D

    [/td]


    [/tr]


    [tr]


    [td]

    Object1

    [/td]


    [td]

    1

    [/td]


    [td]

    0

    [/td]


    [td]

    0

    [/td]


    [td]

    0

    [/td]


    [/tr]


    [tr]


    [td]

    Object2

    [/td]


    [td]

    0

    [/td]


    [td]

    1

    [/td]


    [td]

    1

    [/td]


    [td]

    0

    [/td]


    [/tr]


    [tr]


    [td]

    Object3

    [/td]


    [td]

    1

    [/td]


    [td]

    1

    [/td]


    [td]

    1

    [/td]


    [td]

    1

    [/td]


    [/tr]


    [/TABLE]



    I'm writing a macro code, such that it checks column1 and displays on a text box (actually shape) only where value is greater than 0, so in this case for object 1 it should return- 1 A
    and for object 2 it should indicate, again on another text box-
    1 B
    1 C


    and for object 3, on another text box-
    1 A
    1 B
    1 C
    1 D


    The above table is just a look up table and will be hidden in the excel sheet. The text boxes will be displayed on another sheet.


    Can someone please help me with this. Thanks a lot.


    Chris

  • Re: Display specific values and columns macro code


    Thanks, somewhat around those lines...


    But, I want it to show the value and column name...so as from the table above... object1's textbox will show 1A and object2's textbox will show 1B, 1C and similarly for object3.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!