Not entirely clear what you want to do. If you want to produce a
summary of the totals it can be done easily, if you want the whole set
of cell for each type copied, thgat would require code.

For a summary:

Sheet1
Col A - amount
Col B - set up Data Validation List with the expense type

Sheet2
Enter in a cell =SUMIF(Sheet1ColBRange,Expense type,Sheet1ColARange)
substituting as required.

HTH

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=524209