SOLVED

Sort a list into another sheet

Copper Contributor

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

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@jake_from_liberty 

 

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!
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@jake_from_liberty 

 

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.

View solution in original post