How to automatically paste cells from one sheet to another sheet?

J

Jenni

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

kyleb

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add numbers if cell fill is a certain color; How To? 5
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Auto Merge text from multiple sources 0
substract cells from other cells then forwarding to a different ce 1
Possible to have multiple sheets refer to a master template sheet? 1
Mastersheet to Worksheet data copy - macros? 1
Transporting sum from one sheet to another sheet in same workbook 1
How copy automatically from one sheet to another. 4

Top