can anyone help me with attachment, i need a lot of TLC,
first i would like to do a pi chart that shows me the % of nos to yeses in column H also this must work automatically if i add another row of data and include it in the formula, also if i do a filter on D for example and only show"L2" then the pi chart must only work on visible yeses and nos(got me?).
and finally i would like to open sheets named after the list in "D" eg L1,L2, etc
and as i input more rows then the data would also go to the right sheet as well as on main sheet automatically. and the number of rows in main sheet could be as much as 50,000. hope you can help me , ps i dont know anything about vb , pps if possable can show me how the formulas work
Bookmarks