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

substract cells from other cells then forwarding to a different ce 1
Same formula for each sheet? 4
How to make different cells fill in automatically from one entry? 3
Mastersheet to Worksheet data copy - macros? 1
How to copy a conditional format from one sheet to another? 1
How copy automatically from one sheet to another. 4
Printing pages from Pivot Tables automatically 4
Sheet to sheet copying 2

Top