S
svijay
Hi,
I have got some problem while creating excel template.
My req is as follows.
I need to create an excel template which contains 2 sections (i.e
ranges);
with predefined folmula(s).
but the data Im filling in the ranges dynamically thru a web page that
too reading from
database.
now Im facing the problem while defining the range in the template.
I just defined range 1 as
=OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A:$A),20)
where I fill the data dynamically
Im unable to define range2 in the template bcos I donno the no of rows
that are filled in range1.
So my requirement is I need to define range2 in such a way that it
should read
dynamically the last row of range1 and add one row to that and start
filling
range 2.
And in range 2 I need to apply a formula (i.e which I suppose to define
in template) to
be applied agains values of every alternate row of range and to be
shown
example
in range 2
first row first column get value from database.
User will enter a number in second rows first column
based on the number first rows other columns to be calculated
automatically
and thrid row first column get value from database.
user will enter a number in thrid rows first column.
based on the number thrid rows other columns to be calculated
automatically..
like this it shd work.
So I would like to have any suggestions any one from U for
1. Definiging ranges in template that reads last row of previous
range.
2. Applying formula in alternate rows of range2 so that values
calcuated
automatically.
thanx in advance to all of U.
Cheers
Vijay
I have got some problem while creating excel template.
My req is as follows.
I need to create an excel template which contains 2 sections (i.e
ranges);
with predefined folmula(s).
but the data Im filling in the ranges dynamically thru a web page that
too reading from
database.
now Im facing the problem while defining the range in the template.
I just defined range 1 as
=OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A:$A),20)
where I fill the data dynamically
Im unable to define range2 in the template bcos I donno the no of rows
that are filled in range1.
So my requirement is I need to define range2 in such a way that it
should read
dynamically the last row of range1 and add one row to that and start
filling
range 2.
And in range 2 I need to apply a formula (i.e which I suppose to define
in template) to
be applied agains values of every alternate row of range and to be
shown
example
in range 2
first row first column get value from database.
User will enter a number in second rows first column
based on the number first rows other columns to be calculated
automatically
and thrid row first column get value from database.
user will enter a number in thrid rows first column.
based on the number thrid rows other columns to be calculated
automatically..
like this it shd work.
So I would like to have any suggestions any one from U for
1. Definiging ranges in template that reads last row of previous
range.
2. Applying formula in alternate rows of range2 so that values
calcuated
automatically.
thanx in advance to all of U.
Cheers
Vijay