Shortcut for copying formulas referencing different worksheets
 

--------------------------------------------------------------------------------

I am looking for a shortcut. I am copying the same forumula from Row 1
down the page, but where Row 1 references the next worksheet, Row 2
references the following worksheet, and so on. Is there an easy way to
do this without having to go to each worksheet, find the cell and click
on it? TIA


--
bhigdon
------------------------------------------------------------------------
bhigdon's Profile: http://www.excelforum.com/member.php...o&userid=23686
View this thread: http://www.excelforum.com/showthread...hreadid=383993

Does using an absolute reference work?

$W$5 versus W5


"bhigdon" wrote:


--------------------------------------------------------------------------------

I am looking for a shortcut. I am copying the same forumula from Row 1
down the page, but where Row 1 references the next worksheet, Row 2
references the following worksheet, and so on. Is there an easy way to
do this without having to go to each worksheet, find the cell and click
on it? TIA


--
bhigdon
------------------------------------------------------------------------
bhigdon's Profile: http://www.excelforum.com/member.php...o&userid=23686
View this thread: http://www.excelforum.com/showthread...hreadid=383993