View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RD[_2_] RD[_2_] is offline
external usenet poster
 
Posts: 19
Default referencing cell lnking to another tab in Excel that skips 2 colum

Hi,

I am trying to link every 3rd column in Tab C into Tab A. Is there an easy
way to do this via a formula - I have tried Indirect and column however not
having any luck.

Basically in Tab A on Cell A2:
<Column A <Column B
=Tab C!AB$91 =Tab C!AE$91 etc.
In above case, is there a formula that can help me automate the calculation
in Column C?

Thanks so much!