Forum Discussion
Excel question - auto copy info onto a second sheet
I want to create a spreadsheet where information from some selected cells is duplicated on a second sheet simultaneously. Is there a way to do this? For example, I want to enter property addresses ...
Yes. But your description is not very complete. If you want a more complete answer, you'll have to say quite a bit more of the context in which you want to do that duplication of selected cells. And why.
Added a bit more info. Thanks.
- Did you notice I asked for not only a more complete description of the context for your request, but also the "Why"? What's the purpose for what you're trying to do?
You're clearly a beginner at some level (I say that because the question is quite basic), and for that reason it's also possible that you're designing something that is, in fact, not the best use of Excel. Excel is marvelously powerful, and marvelously powerful tools can be used wisely or not so wisely.
So if you don't mind--and I trust you'll forgive my impertinence in asking this--give a much more complete picture of what your end goal here is, why you think that having sheet two copy some (or all?) of what's one sheet one is the way to accomplish it. Redundancy sometimes makes sense. But often it doesn't. There are ways to extract data from sheet 1 onto sheet 2--myriad ways; the mostappropriate way will depend on your ultimate purpose.