Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help!!!!!!
Pls pls pls take time to read this:
I need to link the values in two separate sheets of the same file. The data that i enter in sheet 1must appear in sheet 2 as follows. the values i enter in A1 must come in A1 A2 must come in A6 A3 must come in A11 A4 must come in A16. the values are to appear in the second sheet with a gap of 5 rows between them. but if i just copy and paste the formula, A1 would be linked to A1, but A6(sheet 2) would be linked to A6(sheet 1) and not A2. Is there any way i can get this done without having to type the formulas individually in each cell. Pls HELP!!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help!!!!!!
In A1 of Sheet 2, enter the formula
=INDEX(Sheet1!A:A,INT(ROW()/5)+1) Then copy A1:A5 (with A2 to A5 still blank) and paste to A6:AXXX where XXX is a multiple of 5. HTH, Bernie MS Excel MVP "Maths" wrote in message ... Pls pls pls take time to read this: I need to link the values in two separate sheets of the same file. The data that i enter in sheet 1must appear in sheet 2 as follows. the values i enter in A1 must come in A1 A2 must come in A6 A3 must come in A11 A4 must come in A16. the values are to appear in the second sheet with a gap of 5 rows between them. but if i just copy and paste the formula, A1 would be linked to A1, but A6(sheet 2) would be linked to A6(sheet 1) and not A2. Is there any way i can get this done without having to type the formulas individually in each cell. Pls HELP!!!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help!!!!!!
On Apr 28, 11:29*pm, "Bernie Deitrick" <deitbe @ consumer dot org
wrote: In A1 of Sheet 2, enter the formula =INDEX(Sheet1!A:A,INT(ROW()/5)+1) Then copy A1:A5 (with A2 to A5 still blank) and paste to A6:AXXX * where XXX is a multiple of 5. HTH, Bernie MS Excel MVP "Maths" wrote in message ... Plsplsplstaketimetoreadthis: I need to link the values in two separate sheets of the same file. The data that i enter in sheet 1must appear in sheet 2 as follows. the values i enter in A1 must come in A1 A2 must come in A6 A3 must come in A11 A4 must come in A16. the values are to appear in the second sheet with a gap of 5 rows between them. but if i just copy and paste the formula, A1 would be linked to A1, but A6(sheet 2) would be linked to A6(sheet 1) and not A2. Is there any way i can get this done without having to type the formulas individually in each cell. PlsHELP!!!!! Got it...... THANX A LOT :):):) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|