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.

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

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