Thread: Cell References
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
I Maycotte I Maycotte is offline
external usenet poster
 
Posts: 1
Default Cell References


Hi everyone,

I'm curious to know if there's a way to add strictly to the number
portion of a cell reference. For example, Sheet 1 cell A1 is linked to
Sheet 2 cell H1. A2 is linked to H4, A3 to H5, etc. So, essentially, I
want to know if it's possible to fill in sheet 1 col A with a formula
like H(i + 2) instead of manually linking cells. Thanks.

-- Isaac Maycotte


--
I Maycotte
------------------------------------------------------------------------
I Maycotte's Profile: http://www.excelforum.com/member.php...o&userid=35604
View this thread: http://www.excelforum.com/showthread...hreadid=562585