Copy--> Paste problem

[thewiseguy]

Hi everyone,

In sheet 2 cell A1, I would like it to equal sheet!A1.

In sheet 2 cell A4, I would like it to equal sheet1!A2.


Is there a way I can make this easy on myself????


TIA.


-m

 

[Lewiy]

Is this going to continue on down the column? i.e.
Sh2 A1 = Sh1 A1
Sh2 A4 = Sh1 A2
Sh2 A7 = Sh1 A3
Sh2 A10 = Sh1 A4
Sh2 A13 = Sh1 A5

 

[thewiseguy]

Is this going to continue on down the column? i.e.
Sh2 A1 = Sh1 A1
Sh2 A4 = Sh1 A2
Sh2 A7 = Sh1 A3
Sh2 A10 = Sh1 A4
Sh2 A13 = Sh1 A5

yes.

 

[Lewiy]

In Sheet2 cell A1 use this formula:

=INDIRECT("Sheet1!A"&((ROW(A1)-1)*3)+1)

and copy it down the column.

 

[thewiseguy]

In Sheet2 cell A1 use this formula:

=INDIRECT("Sheet1!A"&((ROW(A1)-1)*3)+1)

and copy it down the column.

ok now what if sheet2 A1 is really E14 and sheet 1 A1 is really sheet1 A5?

does the formula change?

 

[Lewiy]

It would depend whether the rows are still 3 apart each time, would it be:
E14=A5
E15=A8
E16=A11
etc?

 

[thewiseguy]

It would depend whether the rows are still 3 apart each time, would it be:
E14=A5
E15=A8
E16=A11
etc?

essentially it would look like this:


sheet 1 sheet 2


A5 E14 = A5
A6 E17 = A6
A7 E20 = A7
A8 E23 = A8

 

[Lewiy]

Ok, in Sheet2 E14 use this:

=INDIRECT("Sheet1!A"&(ROW(E14)+1)/3)

then copy it down column E, you will get a #REF error in E15, E16,E18,E19,E21 etc.

Alternatively, just copy and paste that formula into the cells in column E that you want them, i.e. E14,E17,E20,E23.

 

[thewiseguy]

Ok, in Sheet2 E14 use this:

=INDIRECT("Sheet1!A"&(ROW(E14)+1)/3)

then copy it down column E, you will get a #REF error in E15, E16,E18,E19,E21 etc.

Alternatively, just copy and paste that formula into the cells in column E that you want them, i.e. E14,E17,E20,E23.

ahh that worked perfectly. thank you very much!