View Single Post
  #1  
Old April 22nd, 2010, 11:35 PM posted to microsoft.public.excel.worksheet.functions
rrg
external usenet poster
 
Posts: 5
Default Copying Cells with Fill Handle

Can anyone help? I am trying to copy cells across a row using the fill handle
that are referencing another sheet down a column. I am placing a "$" in front
of the letter as to not change it, but since I am copying across, the number
will not change. Is there any way to tell Excel that i want the number to
advance as I copy across?