Conditional Auto-Population

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

I am collecting data in the first worksheet and subsequent
worksheets will contain other views of the same data (with
some additional calculations). Each row in the first
worksheet will fall into one of 4 categories (say A,B,C
and D). Category is identified in Column A. I would like
data from the 'A' rows to populate one worksheet and data
from the 'B', 'C' and 'D' rows to populate another
worksheet. There is no way to predict in advance the order
in which As, Bs, Cs and Ds will occur.

I have tried several methods, but with no success. I am
beginning to wonder if the data collected in the first
worksheet really needs to be in a database, but I don't
really know...

Does anyone know how to solve this problem? Your help
would be greatly appreciated!!!!

Thanks, Lisa
 
I am trying to do a similar operation. I also am collecting data in the first worksheet (All Books) and subsequent worksheets will contain portions of the same data. The other sheets data will depend on the entries in a particular column, say column "C". This is a school library database and entries in this column may be 'Science', 'Animal Stories', 'Social Studies', 'Board Books' or 'Words and Alphabet' as examples. How can I make data entry easier so that new books in the library are entered only in the 'All Books' datasheet, but are divided by "C" (Catogory) into other datasheets, automatically. I've tried to use an if statement like the following, but it hasn't worked. I'm not very sure of how to use this:
=IF('All Books'!C$1,"Early Reader","copy to 'Early Reader'!A2")

Any help would be appreciated. - Natasha
 
Back
Top