View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jenni Jenni is offline
external usenet poster
 
Posts: 5
Default How to automatically paste cells from one sheet to another sheet?

I'm working on an Expenditure file.

12 sheets are for the months of the year and 10 other sheets are for the
categories of various expenses. ie: Medical Expenses.

I'd like to be able to enter a receipts info into the Month sheet and under
the column for DETAILS if I enter Medical (or a formula?) Can I have THAT ROW
referring to that receipt automatically copy to the MEDICAL Sheet also?

Is this at all possible??