I have a formula that I'm using to pull data from a cell on multiple
sheets...The formula is =SUM(Week1!$L$52) This formula I want to use
across the same row, changing the week number in each cell, but not the
cell reference...In other words...the cell next to it would be
=SUM(Week2!$L$52), next one would be week 3, and so on. Is there a
shortcut to doing this so that It will update across the row all the
way to 14?? I have 60 rows of formulas, and it would be easier to just
enter each one ONE time, and copy and paste somehow across the sheet but
keep the formula reference correct.


--
AlienBeans
------------------------------------------------------------------------
AlienBeans's Profile: http://www.excelforum.com/member.php...o&userid=32352
View this thread: http://www.excelforum.com/showthread...hreadid=546580