I am a novice Excel user and here is what I want to do. I have two worksheets. On one, I have a list of expenses. Each expense is coded as to what type of expense it is. So, I want to seperate each code on another worksheet.
I am a novice Excel user and here is what I want to do. I have two worksheets. On one, I have a list of expenses. Each expense is coded as to what type of expense it is. So, I want to seperate each code on another worksheet.
It is about the same as Mels questions...
anyone that can answer this?
If there is a smaller amount of Codes, I'd use PivotTables.
To learn all about PivotTables: http://www.datapigtechnologies.com/ExcelMain.htm
If there is a large amount of Codes, I'd ask the VBA forum.
Ola Sandström
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks