I have no idea if what I'm trying to do is even possible in Excel. If anyone
could shed some light, it would be greatly appreciated!!

I am trying to create a "compounding" document using one tab of the
spreadsheet (Sheet 1) as the source. The original spreadsheet has Program
descriptions in column B, account amount information in column H and the
account number in column I.

In a new tab, I would like to group certain account numbers into categories.
For example, in row 1, I would have a column heading of Instruction. I know
what accounts should fall under this category, so I would like to look up the
account numbers in Sheet 1, Column I, and when it finds the defined account
numbers, display Program description from Sheet 1, column B and the account
amount from Sheet 1, column H, and the account number from Sheet 1, Column I.


For each account that is found, I would like the data to display in a new
row.

Then I would start over, with another category, but in the same spreadsheet.

Is this possible with Excel? Might this be easier done in Access?