cell references to different sheets with lists
 

worksheet B has several cells that reference values from worksheet A
i'd like to make worksheet A a list, because it would make looking a
different groupings on the sheet easier. however, if i reorder sheet
the formulas for sheet B are now not going where i would like them.

any ideas for how i might be able to have sheet B update the formulas

--
TheIrishThu
-----------------------------------------------------------------------
TheIrishThug's Profile: http://www.excelforum.com/member.php...fo&userid=2968
View this thread: http://www.excelforum.com/showthread.php?threadid=49639