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
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