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