Prev: Calculation of Age
Next: pop up calender PT 2
From: Maths on 28 Apr 2010 14:05
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!!!!!
 | 
Pages: 1
Prev: Calculation of Age
Next: pop up calender PT 2