Search data w. use of msg box and copy results to new blanc worksh
 

I have a worksheet named abc. It consists of clien information (a/s/l/,
commitment of contract, service used etc.) What I'd like to do is filter out
all users who have a commitment of x-number of months. The x-number is a
variable and I want to use a msg box to specify the amount of months I'm
looking for (i.e. 24 should mean find all users with commitment of 24
months). After Excel executes this search I want excel to copy the users who
match the requirements to be copied into a blanc worksheet. Is this
possible?! The number of months is located in cel M.

Search data w. use of msg box and copy results to new blanc worksh
 

You could do this kind of thing, but it's usually a bad idea to duplicate your
data.

I'd add data|filter|autofilter to my data (xl2003 menus).

Then I could filter to show just the values I wanted.

If you really wanted the data on a separate worksheet, you could copy the
visible cells to that new worksheet.

And if you really, really wanted a macro to do it, you could record one while
you did it manually.

Basta1980 wrote:

I have a worksheet named abc. It consists of clien information (a/s/l/,
commitment of contract, service used etc.) What I'd like to do is filter out
all users who have a commitment of x-number of months. The x-number is a
variable and I want to use a msg box to specify the amount of months I'm
looking for (i.e. 24 should mean find all users with commitment of 24
months). After Excel executes this search I want excel to copy the users who
match the requirements to be copied into a blanc worksheet. Is this
possible?! The number of months is located in cel M.

--

Dave Peterson

Search data w. use of msg box and copy results to new blanc wo
 

Dave,

Thank you for your suggestion. I guess it's probably so easy it's not
uncommon to overlook the simplicity of some problems.

Thnx anyway

"Dave Peterson" wrote:

You could do this kind of thing, but it's usually a bad idea to duplicate your
data.

I'd add data|filter|autofilter to my data (xl2003 menus).

Then I could filter to show just the values I wanted.

If you really wanted the data on a separate worksheet, you could copy the
visible cells to that new worksheet.

And if you really, really wanted a macro to do it, you could record one while
you did it manually.

Basta1980 wrote:

I have a worksheet named abc. It consists of clien information (a/s/l/,
commitment of contract, service used etc.) What I'd like to do is filter out
all users who have a commitment of x-number of months. The x-number is a
variable and I want to use a msg box to specify the amount of months I'm
looking for (i.e. 24 should mean find all users with commitment of 24
months). After Excel executes this search I want excel to copy the users who
match the requirements to be copied into a blanc worksheet. Is this
possible?! The number of months is located in cel M.

--

Dave Peterson