facing error - subscript out of range - In allocating data in sheet name wise

[prabhuduraraj09]

hi guys,

Need your hands to help me.......here

im here having data in one sheet, at each row...i have given name of user.
also i have created sheets for users.
my code will , move the data in the respective user sheet.

data from one sheet to other sheet.


But once i execute the code, im facing error is -
Run time error 9
Subscript out of range

i dont understand why?.
i said from which column user name has to be picked up and by which select sheet name.
Dont know.......

Could anyone fix it!!!!!!. i here by attached the file for your reference. in which enclosed my code.
Please someone help me...............

[AB33]

Please Login or Register  to view this content.

[arlu1201]

You are getting the error because some rows have blank cells in that column.

You can put a condition in your code to skip all rows containing blank cells in column P or have all these rows shifted to another sheet like "blanks" or "temp".