Extracting data to a list

npbro

New Member
Joined
Feb 19, 2002
Messages
1
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
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Select the Row with your codes then
select DATA, Filter and Autofilter
Then filter on each code and copy the results to another sheet.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,999
Members
448,541
Latest member
iparraguirre89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top