Hello all
I am attempting to use the Define Name feature in Excel 2007 to references a cell that I use to total a column of data, so that I can pull the information from that cell into a different sheet and use it in a chart. Can anyone help with this, I will keep looking but perhaps I am not phrasing my question in a google search correctly.

Also note that the cell that gets the total of information changes with each new data pull, for example one day it may be J350 and the next day it may be J389.

Thanks
Shaun