Thread: Reference every 13th cell from another tab.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jordanpcpre jordanpcpre is offline
external usenet poster
  
Posts: 22
Default Reference every 13th cell from another tab.
Is there a formula that will reference a cell in a seperate tab for every
13th cell.

For example: In cell R7 it looks at cell =+Equity!E166. Cell S7 needs to be
13 rows below =+Equity!E166...

So, R7 equals =+Equity!E166
S7 equals =+Equity!E179
T7 equals =+Equity!E192

I need to repeat this for multiple colums.
Reply With QuoteReply With Quote