Skip to Content
avatar image
Former Member

Dynamic Range Fails When a New Member Added

Hello Everyone,

I have a problem which i think i should not have but the situation is this;

I define the interception of rows and columns as a name in excel below where column is dynamic;


So i expect that if there is a new bank, it will be dynamically in my name but the result i get is below;

Isnt it silly?

Thanks,

Emre

aa.png (3.4 kB)
bb.png (6.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 19, 2015 at 11:43 AM

    Sorry, but absolutely not clear!

    Can you talk in the terms of dimensions, members, row/column axis of the report, etc...

    Vadim

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 19, 2015 at 12:28 PM

    Ok, at that area i would like to do a percentage calculation. The problem appears when we add a new bank because the formula doesnt automatically copied. So, i decided to create a range at that area and with macro i wanted to copy that macro to that range. Do you understand?

    Emre

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 19, 2015 at 12:37 PM

    But i also need to sent the data to the system.

    Emre

    Add comment
    10|10000 characters needed characters exceeded

    • Sorry, but you have to explain your requirements in details with screenshots of the desired result etc...

      Without this info I am unable to help!

      "But i also need to sent the data to the system" - and what?

      Vadim