Creating gender list

**drennjoe** · 03-07-2008, 10:42 AM

Hello I hope someone can help.

I have a worksheet with client names(A) with gender(B).
I need to create a report that seperates by gender.
I have created a sheet on the same work book and hoped it could pull the information from one sheet and automaticaly list females in one column and males in another.

Any help would be apreciated.

**natei6** · 03-07-2008, 12:44 PM

Originally Posted by drennjoe

Hello I hope someone can help.

I have a worksheet with client names(A) with gender(B).
I need to create a report that seperates by gender.
I have created a sheet on the same work book and hoped it could pull the information from one sheet and automaticaly list females in one column and males in another.

Any help would be apreciated.

Can you just sort by column B?

**drennjoe** · 03-07-2008, 02:52 PM

No.
I need to create a report from the data in the spreadsheet for my boss.
Right now I have to manually enter all the names by gender into the report.
I was hoping it would update the information into another worksheet into two columns.
One for male beds occupied and one for female beds.

**protonLeah** · 03-07-2008, 03:06 PM

I don't see the problem with sorting by *** then copy/paste to a new sheet in whatever column you wish for the report. Maybe you should give us more info on the sheet data/layout>

**drennjoe** · 03-07-2008, 04:10 PM

That's pretty much what I do now.
I guess I'm getting lazy in my old age.
I was just hoping to auto copy the info into the report.
It just seems like a simple task to take names from excel sort by gender and copy it to another spread sheet.
I have many reports for many different departments and any automation from a single database would help a lot.

The primary database I use has many columns of data.
Column A has names and column B has gender, for starters.
The report seperates by gender and I have set it up to count male/female and total a Gender Census.

If I could figure the gender part out then I could apply this knowledge to the various disciplines I have to report to.
I have attched the blank report I would like the data to be exported to.

Thanks for any help

**protonLeah** · 03-07-2008, 07:27 PM

That attachment does not help. It only shows what you want the final work to look like, but we already know that from the original post. What we need is the main datasheet from which the report will come. Can you attach a one page spreadsheet with a couple of dozen rows of data with confidential (last names, addresses, etc) info deleted (but leave the column headings)? Otherwise...