I need to be able to change the sheet reference in a chart by selecting
a cell that has the sheet name. Each sheets data are in the same cells.
I just need to reference different sheets. Example: if the current
values are referenced by =Sheet1!$B$3:$B$8 then I need to be able to
change Sheet1 to Sheet 2 without changing the other data example:
=Sheet2!$B$3:$b$8 or =Sheet5!$B$3:$b$8


--
DBDEZYNE
------------------------------------------------------------------------
DBDEZYNE's Profile: http://www.excelforum.com/member.php...o&userid=27095
View this thread: http://www.excelforum.com/showthread...hreadid=466120