I have macro for autofilter i need suprate sheet for ever variable

Sir i am uploading a file with my data and macro which i use in the drop box

https://www.dropbox.com/s/wm7evyhelh...ata%20new.xlsm

about the file
this is a sample data which i am uploding in actully the data is huge in the count of lacks
and the macro which i am useing is to auto filter D column data name ("L-J")
in this there are 36 veriable to be suprate with a line gap which the macro is doing

what i want to do

in the paste sheet if you see
the filtered date is there after a line gap after a each veriable (ie 1a,1b,2a,2b, ....... upto 12b(R) )

now i want is macro to create a new sheet in the name of example ( "L-J (1a)" ,"L-J (2b)" )
where "L-J" is D column name and "(1a)" is the autofilter suprated data in suprate sheet

any more clification please reply

thank you

sir not able to uploade it on the forum because the file is of 3 mb it is not taking
i tried it

harish

no sir i want to suppurate it with different sheet so that i can further filter according to my requirement

thank you for early reply

harish

Hi Harish,
try it

Please Login or Register  to view this content.

it working sir but changes
can you make two more changes

Please Login or Register  to view this content.

instead of row number can you make it row name
(ie instead of .Column(4) you can give me option (D:D) any thing like this
this is because i need to segregate 4 levels
ie after d column i need to run macro for H column on indiviual sheet (L-R)
and suppurate them
and again i need to select each sheet of L-R single sheet and suprate them with I column ie(L-ME)
and then for G column (ie L-mo ) and join data in one sheet

in simple with example

first run macro of yours
and select one sheet from that sheet example (sheet name "L-J(1a)" and change the name to data criteria to column num 8(H column filter)
and name it as "L-R(1a) and so on
after completing that
one sheet from that sheet example (sheet name "L-R(1a)" and change the name to data criteria to column num 9 (I column filter)
and name it as "L-ME(1a) and so on
and in last
one sheet from that sheet example (sheet name "L-ME(1a)" and change the name to data criteria to column num 7 (G column filter)
and name it as "L-MO(1a) and so on

and copy all data in one sheet
all data in series of

1a,1a(R),1b,1b(R),2a,2a(R) ..............12b,12b(R)

thank you for your time
this is my actual problem

any doubt reply back
thank you
harish

sir have you got confused with what actually i need
sorry for my bad English
as the data is in bulk in lacks it is taking lot of time
my be it is impossible to do so
i am just trying my level best to get it done

i just need to filter four level and then arrange it in one sheet
for this i am doing all circus

first auto filter in D column suppurate data select first filtered criteria data
auto filter H column in that select first filtered data
auto-filter on I column in that select first data
filter on g column and paste it in a sheet
and
then second filtered data on i column
filter it on G column and paste it in the above paste sheet like this on all the filtered data of i column
back to H column second filter data then follow the above process

thank you in advance

Harish

Harish, it is still unclear
maybe it would be better to show a small sample file with the desired result.

sir thank you for your reply
i am up loading the file in the drop box

https://www.dropbox.com/s/5aecrez6aw...atacolour.xlsm

if you open it you will see 3 sheets one is data (full data )
2nd sheet it is L-J(1a) i have taken as reference
3rd sheet "I need" (4 level filter which i have done manually with color difference in four column

brief in column D i have given pink color
1st level "1a" in column D (it is example in my data i have 24 variables actully
in column H there are two parts ("8a" and "8B") ie 2nd level
first i have taken "8a"
in 3rd level there is 4 parts ie ("8b" , 9a , 9b , "10a") i will select one after one first i have select 8b
in the I column then in the last
in fourth level is in the G column
i will sap prate it with a line gap with individual variable for you understanding changing colors for each variable
and pasted it
then again went back to to 3rd level selected "9a"
like this
still having any dout please reply
i will try my level best to explain you

thank you

harish

but this is a simple sort if I understand correctly
try

Please Login or Register  to view this content.

yes sir you have understood properly
i want to sort for data sheet and create new sorted sheet

with 2 more changes
1) add one more sort

1st to D column
2nd to H column
3rd to I column
4th to G column

2) insted of ascending order can you make custom sort in the given order (actually my work requirement in this order)

1a,1a( R ),1b,1b( R ),2a,2a( R ),2b,2b( R ),3a,3a( R ),3b,3b( R ),4a,4a( R ),4b,4b( R ),5a,5a( R ),5b,5b( R ),6a,6a( R ),

6b,6b( R ),7a,7a( R ),7b,7b( R ),8a,8a( R ),8b,8b( R ),9a,9a( R ),9b,9b( R ),10a,10a( R ),10b,10b( R ),11a,11a( R ),11b,11b( R ),12a,12a( R ),12b,12b( R ),

it will be very helpful for my work

thank you in advance
and even understanding my problem

harish

Hi Harish,
try so

Please Login or Register  to view this content.

sir thank you for your reply

sir i need the sorted data in one more sheet not with the same sheet
the data is not sorting with the custom sort which i have given

sir one more request
if you could give me option of selecting column will be more help full
example
Input box nu 1 " D " column or "D1:D (how ever you prefer)
Input box nu 2 " Y "
Input box nu 3 " AA "
Input box nu 4 " BA " (column names)

and the codes you have given is fixed to this sheet only
sir i have huge data in lacks of rows and 80-100 columns
and i need to analyse some with different combination also

sir i am really sorry for disturbing again and again

sincirealy thanking you
for you valuable help for my project
which i wanted to do and which is really taking lot and lot of time to sort the data

HARISH

Harish,
Okay, you can create a form to select columns. But why to sort each worksheet?
I think you can do the sorting on the original sheet "Data" and split it into individual sheets by the values (1a, 1b, 2a etc.) ​​in column D ("L-J"). Right?

sir sorry i thought it will be very difficult to 4 way sorting in vba or even in excel
for that reason i was splitting the data in each level and doing it manually each step
ie sorting 2 level and then third level and last fourth level

i actually sort data sheet in one more sheet verify in it only

if 4 level sorting is possible then i don't need "L-J(1a) " sup prate sup-rate sheets for each variable

and if it is custom sort as i given variable then it will be very easy to analyse thing and even faster also


any further doubt please replay

thank you
harish

sir really its wonderful you have done it
which have done my job very very easy

one more thing
can you make one more sheet for sorting
let the data sheet be there without any changes
and after i run macro one more sheet to be created by name sorted and sorted data should be saved in it

sincerely

thank you very very much

harish

Harish, just copy the sheet "Data" and run the macro for the active worksheet. You can make as many copies as you need. I think that it does not need to write a macro.

ok sir i got it
now once again thank you sir
for you full dedicated work
with lot of patience

last and final

nice to have you on the forum
sincerely thank you

harish