Getting Dynamic ranges to work properly

[ncarrocino]

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

Please Login or Register  to view this content.

Can anyone see another solution to this? thanks

heres the file

Nano Filtration for liz.xls

[Pepe Le Mokko]

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