Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get cells on a sheet to automatically fit data? | Excel Worksheet Functions | |||
Copy and paste cahrt to new sheet-update data automatically? | Charts and Charting in Excel | |||
Can cells be copies automatically to Sheet 2 and Sheet 3 | New Users to Excel | |||
Paste Cells With Data To Another Sheet | Excel Discussion (Misc queries) | |||
create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) |