Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set it so my tab key skips to the next cell not 6? | Excel Discussion (Misc queries) | |||
How do I set up a function that skips a cell in a fill? | Excel Worksheet Functions | |||
can't tab to next cell skips to end of line? | Excel Discussion (Misc queries) | |||
How do I make a spreadsheet that skips each cell and adds color | Excel Discussion (Misc queries) | |||
Sum function not working correctly in Excel (Skips Cell) | Excel Worksheet Functions |