Linking Number of Rows in Two Tables

Hi there,

I need a help in linking the number of rows in two tables in different sheet, so that I am using Table 1 in sheet 1 as an input table, and Table2 in Sheet 2 to read from it. I know how to read the data "i.e. =Sheet1!A1" but I dont know how to add a new line to the table and extend the folmula to the new row if added.

I am attaching a file hope to explain more

The simplest solution would be to create the formulae in advance on the 2nd table, eg:

Please Login or Register  to view this content.

repeat the ROWS test logic for columns B & C