I have an Excel document with 2 worksheets. The first worksheet is a data
input sheet. The second worksheet performs some calculations based on the
data input from the first worksheet. Currently there is space for 10 rows of
data input (with corresponding calculations in the second worksheet). If
more than 10 rows of data is needed, is there a way to automatically add an
extra row on both worksheets?

Hi,

If your first sheet is a data input and the second sheet performs some
calculation based on the first sheet, then you cannot automatically enter
additional rows. You to have manually enter the rows.

However, Since there are few references already defined in the second
worksheet, you must enter new lines between those rows to automatically
increase the references to these addtinal rows.

Like wise if you understand the way you have defined references between the
first and the second worksheet, you organize the layout accordingly.

Challa Prabhu

"Copytax" wrote:

I have an Excel document with 2 worksheets. The first worksheet is a data
input sheet. The second worksheet performs some calculations based on the
data input from the first worksheet. Currently there is space for 10 rows of
data input (with corresponding calculations in the second worksheet). If
more than 10 rows of data is needed, is there a way to automatically add an
extra row on both worksheets?

A friend told me that he thought it might be possible to do what I have
described with a macro. Do you know if that is true?

"challa prabhu" wrote:

Hi,

If your first sheet is a data input and the second sheet performs some
calculation based on the first sheet, then you cannot automatically enter
additional rows. You to have manually enter the rows.

However, Since there are few references already defined in the second
worksheet, you must enter new lines between those rows to automatically
increase the references to these addtinal rows.

Like wise if you understand the way you have defined references between the
first and the second worksheet, you organize the layout accordingly.

Challa Prabhu

"Copytax" wrote:

I have an Excel document with 2 worksheets. The first worksheet is a data
input sheet. The second worksheet performs some calculations based on the
data input from the first worksheet. Currently there is space for 10 rows of
data input (with corresponding calculations in the second worksheet). If
more than 10 rows of data is needed, is there a way to automatically add an
extra row on both worksheets?