Sure. Create a column on your primary sheet that will ist the status of the
patient as the patient is admitted or released. Create a two more worksheets
that will also list your patients (copy or link). When it's time to run your
report, concatenate the columns on your primary sheet that lists your
patients and their status. On your other two worksheets, run a vlookup
against your first sheet to look for the concatenated info (patient
name-status). You'll want to create two sheets...one for admitted
patients...one for released patients. Of course, you'll run a vlookup on the
admitted patients that will show "patient name-admitted" (for instance)...and
a vlookup on the released patients that will show "patient
name-released"...on the two separate worksheets. Your two secondary
worksheets will separate the admitted and released patients.

"Denise" wrote:

I have a very large spreadsheet that has approximately 41 columns and 3000
rows. A new sheet is started every month.

Is there a way that I can have information from the main sheet transfer to
another sheet if column E is equal to a certain name?

Example - every patient that went home I want to transfer on a separate
sheet, every patient that was admitted I want to transfer on a separate
sheet.

Thanks for any help.