I've posted a link in a the 'charting forum', but it's more of a general question stemming from a charting issue. Link to other forum is below for maybe more detail?

I've created a dynamic link called 'namelist' and it uses offset to dynamically change the size of the list as items are added or subtracted:

=OFFSET(sheet1!$a$1,0,0,COUNTA(sheet1!$a:$a),1)

Now I have a second sheet ("sheet2") that is very similar, but may have more or less entries than sheet1. I'd like to have this exact same dynamic list function for "sheet2", but the offset command references a SPECIFIC sheet, which really doesn't allow me to do what I want... is there a way around this?


http://www.excelforum.com/showthread.php?t=602018