Which function do I need to do this

[xirokx]

Hey peeps,

I have setup 2 worksheets within the same workbook when I enter values
in cells in worksheet 1 I have chosen certain cells to be displayed in
worksheet 2also.

Now I want excel to realise that in worksheet 2 all cells are full for
lets call it that query so return the value in a new row....

Which function would I use?

I hope I have explained this clearly enough?

Anyhelp would be appreciated......

Thanks in advance....

 

[Peo Sjoblom]

How would excel realize that? Any criteria etc? A function can only return a
value to the cell that holds the function so
if you want to use functions you would need functions in those new rows that
will somehow use a criteria that for instance tell them that if A has less
than 25 numeric entries return blank "" if more return the total of A
All other ways would include using event macros
--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[xirokx]

could I for instance insert a new column and manually type 1 there once
I have added all relevant data and that row is completed? Therefore
next time I enter some more info it will realise there is a 1 in the
column which means it should input the data in the next row?

Alternatively any suggestions how I could make this work?

I understand what you are saying re: criteria but the only criteria I
would like excel to follow is to realise that there is now information
in 10 columns so can it display the info in another row?