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

Type an equals sign in the cell you want the information to end up in, click
over to another worksheet, and click on the cell you want to reference.
Excel will automatically enter it in.

"Jenni" wrote:

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??