Basic question-selecting cells

[wdbouk]

Hi,

in sheet 2 , I am selecting cells of sheet 1 that are incremental by 10, for example Sheet2!A1 should have the value of Sheet1!A3, Sheet2!A2 should have the value of Sheet1!A13, Sheet2!A3 should have the value Sheet1!A23 etc... I am wondering how to do it (the data is large) by writing a formula in the cells of sheet 2 and simply drag the cursor to fill the values instead of doing it one by one.
Best

 

[SkipVought]

Hi,

There is no reason to have to WRITE the sheet!range reference in any formula. You simply point to that sheet tab/range and the reference is WRITTEN be Excel.

There is no reason to repeat a formula in anoter cell. You simply either copy and paste into the range.

Check HELP.

Skip,

_[red][/red]

 

[wdbouk]

most probably u misunderstood my question or I misunderstood ur answer. pointing to sheet1 would oblige me to do it for every cell in sheet2 since the values of sheet 2 oblige me to select an observation from every 10 observations in sheet 1. I am simply wondering if I could make sheet2 cells written such as :A1=Sheet1!A3,A2=Sheet1!A13,A3=Sheet1!A23 etc..

 

[SkipVought]

There is no reason to repeat a formula in anoter cell. You simply either copy and paste into the range.

Skip,

_[red][/red]

 

[GlennUK]

I am simply wondering if I could make sheet2 cells written such as :A1=Sheet1!A3,A2=Sheet1!A13,A3=Sheet1!A23 etc

You can calculate the offset to the cell you want like this:

=OFFSET(Sheet1!$A$1,(ROW()-1)*10+2,0,1,1)

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.