Thread: How do I copy formulas but using the same range each time I copy
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
neilcarden
 
Posts: n/a
Default How do I copy formulas but using the same range each time I copy

Just going off on a tangent, I want my formula to stay the same when
dragged from left to right, so the $ works fine, but I want the Sheet
reference to change.

The sheets are Apr06, May06, Jun06 etc.. and are in consecutive order,
is there anyway to accomplish this??

Thanks


--
neilcarden
------------------------------------------------------------------------
neilcarden's Profile: http://www.excelforum.com/member.php...o&userid=35623
View this thread: http://www.excelforum.com/showthread...hreadid=554594

Reply With QuoteReply With Quote