+ Reply to Thread
Results 1 to 2 of 2

Getting Dynamic ranges to work properly

  1. #1
    Registered User
    Join Date
    04-22-2011
    Location
    nj
    MS-Off Ver
    Excel 2010
    Posts
    24

    Getting Dynamic ranges to work properly

    I have a program working how i want it to work except for it is very sloppy coding. I was trying to make each category in my chart a dynamic range since it is always growing. I am using a drop down menu (in S4) to the right of the chart on the left (where all the data is displayed) with a list based on what is selected in the drop down. I am currently using an offset and indirect formula but when i created the dynamic ranges they would no longer work properly.

    to make my dynamic ranges i was using the code
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Can anyone see another solution to this? thanks

    heres the file

    Nano Filtration for liz.xls

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,743

    Re: Getting Dynamic ranges to work properly

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

    http://www.excelforum.com/excel-form...12#post3114912

    You can BUMP your existing thread if needed

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1