Need excel help

Hello,

I'm using excel2007. I'm not sure how best to approach this problem. I'm pretty competent at excel but I don't know how to do any Visual Basic programming in excel. I've used Pivot tables before, but I'm not sure if they'd help in this case. I'd appreciate any help.

I have a large excel sheet, 50,000 rows, with the following fields.
Employee#, Name, Sales, Department.

What I'd like to do is find a quick and easy way to filter by Department and copy that info to a new worksheet, so each worksheet contains: Employee#, Name, Sales, for only that Department.

About the fields:
Employee# is a unique number.
Name is a persons name
Sales is a dollar amount
Department is a word, e.g. Auto, Housewares, Tools, etc. There's about 90 different departments.

An Employee can have sales in more than one department.

Thank You

 

Your best bet is to ask someone in the MrExcel forum. Someone will probably create and post the code for you. However, you need to read tutorials on how to implement the code into the excel sheet before doing this.

Excel Questions - MrExcel Message Board

 

You could filter the sheet by each department and just copy that data. Are you going to need these to be automatically sorted as data is added or will you just prepare reports each period?

 

Look up "Filter" in the Excel help menu. Once you understand how this works, follow the instructions and apply the filter headings to your spreadsheet. Then using the filter switches, sort or filter the results by department and copy the records to the new worksheets.