Cross Sheet Linking problem

**farmertml** · 03-19-2010, 07:04 AM

Hi,

I'm trying to create a link from one sheet to another which takes the data from a list of thousands in another sheet at 12 cell increments.

For example, I have 2 sheets, the first called "means" which I have all the thousands of data in column C2:1000. (Starts at C2 as there is a heading in C1)

What I want to achieve is to get a list on my other sheet "summary" of the values at each 12 increments starting from C2, C14, C26 etc etc.

I know this is achieveable manually by doing =Means!C2 =Means!C14 =Means!C26 etc etc but that's a labourious task.

Any ideas?

Many thanks for your time.

**dsingh3** · 03-19-2010, 07:20 AM

Hi,
As I m understanding you want the same data from "means" file Range C2:C1000 on "summary" file. Then what you need to do is Copy that data and use paste special function check on paste link and OK. The changes you will made on "means" file, that would be automaticly incorporated in "summary" file.
Pls let me know is it helpful for you or not.

**farmertml** · 03-19-2010, 07:25 AM

Hi Dsingh3,

Thanks for your response. I'll try and explain a little clearer what I'm trying to achieve.
I have a list of data in C2:1000 on the 'means' sheet. On my summary sheet I only need the data from each 12th cell down the list from the means sheet.
I.E.

C2,
C14,
C26,
C38,
C50,
C62,
C74,
C86
etc etc

I dont need the data inbetween these numbers.
I know I could do it manually but I have alot of data to work with and I think it would take a very long time to achieve.I hope that makes it clearer.

Paul

**DonkeyOte** · 03-19-2010, 08:35 AM

Paul, you can use INDEX to do this.

You don't specify where the first link is placed - for sake of demo let's assume B2 (adjust references as nec.)

B2: =INDEX(Means!$C$2:$C$1000,1+12*(ROWS(B$2:B2)-1))
copied down

(other options would be INDIRECT, OFFSET but both - unlike the above - are Volatile)