D
Darin Kramer
Hi There,
Situation...
Data stored in area A1 to Z1000
Column K stores Type - which is a 3-5 digit code. (there are many types)
Assume - Type 1 = ABC
Type 2 = DEF
Type 3 = GHI
I would like to create macro that produces a pop up box that enables
user to enter the types he would like to filter on, and then copies and
pastes it to a new book, to be named of the filtered selection
Thus, if user wants type 2 and type 3, he would run macro, enter ABC as
first filter, DEF as second Filter, click ok, and new sheet called
ABC_DEF pops up with ALL columns (ie A to Z) but only for type ABC and
DEF.
Also could I specify up to 5 different types to run at same time?
Its realtively easy to do with normal filter Macros, but problem is you
have to DEFINE the abc and DEF, As there are more possibilites than I
can write macros for, I would like user to be able to specify....
Posssible...?
I appreicate any assistance....
Thanks
Regards
Darin
*** Sent via Developersdex http://www.developersdex.com ***
Situation...
Data stored in area A1 to Z1000
Column K stores Type - which is a 3-5 digit code. (there are many types)
Assume - Type 1 = ABC
Type 2 = DEF
Type 3 = GHI
I would like to create macro that produces a pop up box that enables
user to enter the types he would like to filter on, and then copies and
pastes it to a new book, to be named of the filtered selection
Thus, if user wants type 2 and type 3, he would run macro, enter ABC as
first filter, DEF as second Filter, click ok, and new sheet called
ABC_DEF pops up with ALL columns (ie A to Z) but only for type ABC and
DEF.
Also could I specify up to 5 different types to run at same time?
Its realtively easy to do with normal filter Macros, but problem is you
have to DEFINE the abc and DEF, As there are more possibilites than I
can write macros for, I would like user to be able to specify....
Posssible...?
I appreicate any assistance....
Thanks
Regards
Darin
*** Sent via Developersdex http://www.developersdex.com ***