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?? |
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?? |
All times are GMT +1. The time now is 05:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com