Recent content by a_83

2003

Thanks for your reply. Is the any way the above can be achieved using formulas only.... Bcoz macro code is not supported on unix platform.

I need to hide row/rows depending upon a cell value.

Yes I went through the post.... This post helps when we are inserting rows in a table..But in my case as i said in earlier post need to have dynamic range from "a" row to 1 row above "Total". In the sheet I am using this formula...

Hui thanks for your reply I tried the solution but its not helping me.. for e.g this the table Name Value a 5 b 10 c 20 Total 35 Now rows will be getting inserted after c. Is there any way that we can dynamic range from "a" row and one row above "Total".

Suppose one my chart has this formula: =SERIES(,,Sheet1!$B$5:$B$11,1) Is it possible to have the range(B5:B11)to be dynamic ie the function should pick up values at runtime. Also is there any solution without macro code i.e only excel formulas.