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!

referencing cell lnking to another tab in Excel that skips 2 colum
 

One way, use this in the startcell:
=OFFSET('Tab C'!AB$91,,COLUMNS($A:A)*2-2)
Above returns the same as: ='Tab C'!AB$91
(note that I assumed the source sheetname is: Tab C)
Just copy the startcell across to extract it exactly as desired
Success? wave it, hit YES below
--
Max
Singapore
---
"RD" wrote:
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!

referencing cell lnking to another tab in Excel that skips 2 colum
 

Try this in column A
=INDIRECT("Tab2!R91C"&(28+(COLUMN()-1)*3),FALSE)
then drag across to columns B, C, D etc

If you start in a column other than A, adjust the 28 down 1 for every column
you move to the right.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
email address: remove uppercase characters

"RD" wrote in message
...
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!