Home » Forums » Open Source Learning Center » Question and Answer

Automatic Data input to sheet 2, 3 etc.

Submitted by RyanO on 1 March, 2012 - 22:37

I have a register of entrants.
Columns FOR ALL SHEETS Are:
Rider Name | Race Number | Class

The class is selected from a list.

Is there a way I can have the data transfered into a seperate sheet (NAME,NUMBER,CLASS) after a have selected the entrants appropriate class.

i.e. Classes are X, Y, Z.
Sheet 1 has all entrants in a list.
Sheet 2 I would like anyone I input as Class X to appear here.
Sheet 3 I would like anyone I input as Class Y to appear here.
Sheet 4 I would like anyone I input as Class Z to appear here.

basically as I input data into sheet 1, I want it to be automatically populated into seperate sheets depending one what class is selected.

Is this possible?

Thanks for any help.

‹ could not set the value property. type mismatch error what does this mean? Non-Linear interpolation ›
»

Ok, So I have the formula

Submitted by RyanO on 2 March, 2012 - 05:56.

Ok,

So I have the formula which is filling out the forms for me
=IF(Sheet1!C2="PSR",A2)

But the following lines if not "PSR" are submitting 'FALSE'
is there anyway to have the data added to the following line only if it is "PSR" so that no false and no blank cells are present?

»