Output filter result to new worksheet ?

F

FoxrtotEcho

I have worksheet that contains 6 columns i.e name ,
department gender etc. Under each department I have the
total number of personel .
I need to produce an alphabetical list in another
worksheet that shows only name and department.
What function can I use to output the information from the
master worksheet to the Alpabetical worksheet?. I have
conditionally formatted the totals on the master worksheet
so theyre displayed when a print out is selected but not
the Dept title.
Hope I´ve made myself clear and thanks for any tips!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match a value to multple criteria both in rows and columns 3
Hyperlink imported data into worksheet with dated formate 0
copying & Pasting Multiple Ranges within a workbook 2
Refering cell to the worksheet name 6
Listing Data with Certain Qualifications 6
Pulling a cell reference--clickable cells? 1
producing a report via a keyword - filtering and macros not suitab 2
Copying Selective Data Between Worksheets 5

Top