Hi twinny...
I attached your sample workbook to this thread with a possible solution. When selecting an entry from your listbox, you can use the linked cell to calculate the corresponding cell address in the data sheet. The formula for doing this uses the Excel functions Address() and Indirect():
I have added some helping cells to you chart sheet. Hope this helps.Code:=INDIRECT(ADDRESS(Calculated_Row_Number;Calculated_Col_Number;;;Sheet_Name))
Regards :-)
Bookmarks