Extracting data to a list

[npbro]

Hi,

I'm trying to run an accounts system for a club using excel. I have one sheet where I enter expenses, details, and codes...it looks something like this:

code cost details
AA 1.00 item 1
BB 3.00 item 2
AA 4.00 item 3
CC 5.00 item 4
BB 12.00 item 5

I want to create a separate worksheet for each code, for instance worksheet AA would have the cost and details for the two items with AA code, and so on.

I'm not sure what's the way to do this using excel - I've tried a simple VLOOKUP, but that only finds the first entry using each code.

Any help would be greatly appreciated - I'm a real beginner at using the finding and referencing capabilities of excel.

Thanks a lot,

Nick Brown

 

[vngirl]

[No message]

 

[Guest]

Select the Row with your codes then
select DATA, Filter and Autofilter
Then filter on each code and copy the results to another sheet.

 

[Jack in the UK]

TO ADD TO THAT PASTE THE SELECTION ONLY


Visable cells not just paste.

Rdgs
==========
Jack

 

[Eli Weiss]

Hi Nick,
You can use a pivot table here and put the CODE into page. This will put your codes in different pages in the pivot table.
Eli
This message was edited by Eli Weiss on 2002-02-21 23:41