J
John@ATP
NOTE: To clarify what I have described below I have attached
screenshot.
I am trying to fill a table (18 rows by 50 columns) on a seperate shee
(called 'Data') from another sheet (called 'Sheet1') containing
column of 900 cells of data.
The thing is each of the 900 cells is actually 4 merged rows (so ther
are actually 3600 rows). So the cells containing the data are labele
as $J7, $J11, $J15, $J19...... etc.
The table must be filled sequentially (i.e. from left to right the
onto the next line) from the column of 900 cells containing the data.
How can I do this ?
Is it possible to insert a formula when pointing to a cell, somethin
like "=Sheet1!$J(B1+6)" which would give me "=Sheet1!$J7", and the
autofill it ?
Refereing to the attached screenshot...
Screenshot REF A:
I want cell B2 to =Sheet1!$J7
Screenshot REF B:
I want cell C2 to =Sheet1!$J11 (and D2=Sheet1!$J15, E2=Sheet1!$J19 an
so on.....)
Screenshot REF C:
Is the data on Sheet1 in cell J7
Screenshot REF D:
Is the data on Sheet1 in cell J11
[image: c:\ecul\excel.jpg
screenshot.
I am trying to fill a table (18 rows by 50 columns) on a seperate shee
(called 'Data') from another sheet (called 'Sheet1') containing
column of 900 cells of data.
The thing is each of the 900 cells is actually 4 merged rows (so ther
are actually 3600 rows). So the cells containing the data are labele
as $J7, $J11, $J15, $J19...... etc.
The table must be filled sequentially (i.e. from left to right the
onto the next line) from the column of 900 cells containing the data.
How can I do this ?
Is it possible to insert a formula when pointing to a cell, somethin
like "=Sheet1!$J(B1+6)" which would give me "=Sheet1!$J7", and the
autofill it ?
Refereing to the attached screenshot...
Screenshot REF A:
I want cell B2 to =Sheet1!$J7
Screenshot REF B:
I want cell C2 to =Sheet1!$J11 (and D2=Sheet1!$J15, E2=Sheet1!$J19 an
so on.....)
Screenshot REF C:
Is the data on Sheet1 in cell J7
Screenshot REF D:
Is the data on Sheet1 in cell J11
[image: c:\ecul\excel.jpg