Forum Discussion
Sort a list into another sheet
Hello everyone!
Here is my problem. I need to copy data from one sheet into another. This is an easy thing to do; however, I cannot figure out one small part.
As part of the data, there is a drop-down selection to be part of group 1, group 2, or group 3. I want all of group 1 to go to one sheet, group 2 to another, and group 3 to another. Then, if that group changes in the initial data sheet, the data moves to its resp
If you want it to keep up to date dynamically, I think you should be using (which will require a relatively new version of Excel).....keep you main sheet as the spot where you maintain data, and let FILTER extract the relevant names (and associated data) on a dynamic, real-time basis.
2 Replies
If you want it to keep up to date dynamically, I think you should be using (which will require a relatively new version of Excel).....keep you main sheet as the spot where you maintain data, and let FILTER extract the relevant names (and associated data) on a dynamic, real-time basis.
- That worked perfectly! Thank you so much for the help!
