Need help with macro to get all corresponding row data when matches to adjacent cell value

[toofani]

Dear Pros

I have edited one macro to get my work around to get all the data from a column E make sheets by the values and copy the corresponding data to sheets.

But i can not copy the data, sheets have been created. can any body look into the matter and help

Further to add there might b 10 sheets with different ranges and 9 departments for which sheets would be made.

[LeoTaxi]

Try like this

Please Login or Register  to view this content.

Kind regards
Leo

[toofani]

Thanks Leo but it is not getting all the data, have you checked it. I want it to run and get all corresponding data of values present in column and make sheet of that column value. is there any thing like wks = Activesheet to wks = allsheets ? i need a work around for this

Will be obliged for the help

[toofani]

I need macro to get data from all sheets, not just from active sheet ?? is it possible please help

[LeoTaxi]

Maybe like this, IF columns have the same kind of data in each sheet

Please Login or Register  to view this content.

Kind regards
Leo

[toofani]

Untitled.png

when i click debug this line is highligted rng.AutoFilter field:=5, Criteria1:=arr(i) can anybody help

[LeoTaxi]

it is working in this file


Kind regards
Leo

[toofani]

but when i use it with bigger data file, it gives this error .. which i showed you.. the data which is provided is a dummy data, there are nine departments for which sheets would be created and there are 10 different sheets from which macro will pull out the data..

[LeoTaxi]

without the file i have no idee


Kind regards
Leo

[toofani]

file is attached

[LeoTaxi]

One of the sheets has the autofilter in column E, thats wy

so this take care of it

Please Login or Register  to view this content.

Kind regards
Leo

[toofani]

thank you very much

[toofani]

Dear Leo

One last time i would like to request you to look at this file, when i run the file two names are repeating in each sheet one is from Sindh Urban Last name and one is from nominee first one

Please help to find me the error so i can correct it for further use, rest its working perfectly

I have highlighted the names in each sheet created.

And one addition can i add another empty column on right side and borders to all the column with the code


Appreciated your help alot, last one is requested

[LeoTaxi]

2 modifications, marked in red for the wrong names in sheets
extra part for the borders.

Please Login or Register  to view this content.

Kind regards
Leo

[toofani]

wow thanks alotttttt really helpful and will help me in future use

[toofani]

Dear LEO

Again bothering you! but still one name appears in all sheets Yousuf Abdi when we run the macro. it belongs from PG and appearing in all sheets. its present in Nomination sheet

[LeoTaxi]

Hi Toofani,

i dont wy but i had the same until i changed (increase) the row hight from sheets nomination row 1
so try this first.

Kind regards
Leo

[toofani]

yup did the job