| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy data that matches criteria in one worksheet to another worksh | Excel Worksheet Functions | |||
| Can I use cell data for a web search & bring back in the results? | Excel Worksheet Functions | |||
| Search then copy and past data | Excel Programming | |||
| "" not completely blanc if copy | Excel Discussion (Misc queries) | |||
| I cant do a search on this forum. Everytime I search, it comes up with zero results | Excel Programming | |||
Threaded Mode
