How to automatically update one Excel worksheet from another?
January 4, 2011 8:52 PM Subscribe
Help with Excel! Is it possible to send specific information from one worksheet to another worksheet automatically?
posted by Kutsuwamushi to computers & internet (9 answers total)
I'm helping my family create Excel spreadsheets to keep track of the family business. I knew next to nothing about Excel before starting this project a couple of weeks ago, and while I've learned a little bit, I still don't know if this is possible or how to do it if it is.
Say I have a worksheet titled "all expenses." Then I have other worksheets in the same file titled "rental," "repair," "labor"... or something like that. What would be really helpful is if there is some way to send all rows describing rental expenses automatically to the rental expenses worksheet. This would a) save time, and b) save headache, since I wouldn't have to rely on my family remembering to enter it in twice.
(The reason that I think we need separate worksheets is that each of these categories needs to be further subcategorized, and it's much easier for my parents to understand what they're looking at if the major categories are separated out from each other. I know that separate worksheets aren't necessary to keep track of expenses by category.)
I have some Excel books but honestly there's so much information in them that it's overwhelming to find/understand the specific information I need. Any Excel whizzes out there who can help?
Special bonus question: is it possible to do this between different Excel FILES as well?