Thread: Offset Q
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Seanie Seanie is offline
external usenet poster
 
Posts: 202
Default Offset Q

Could someone help me figure out the offset function

I have a reference in cell AG2 of =Fig!K10, I want to drag this to AS2
with values of =Fig!K11; =Fig!K12 etc etc

How can I do that without entering all these references manually?