Vba is not working

[Solomon14all]

Hi everyone,

i want filter by emp id. And run the macro. In the attached file the macro is not working. Please help me.

Regards,
raj

[JosephP]

please be more specific than 'not working' ;-)

[Solomon14all]

in B2 i type the EMP NO and when i run the macro it should filter by the EMP NO. THIS IS NOT HAPPENING BECAUSE I THINK THERE IS SOME CODING MISTAKE IN THE MACRO. BASICALLY THIS MACRO I COPY AND PASTED. TRULY I DONT NO ANYTHING ABOUT VBA. I NEED A CORRECTION IN VBA.
REGARDS,
RAJ

[JosephP]

posting in capital letters is considered shouting so please do not do it

[xlashraf]

Hi Solomon14all,
Can you please elaborate on what exactly you want the code to do. that will help us propose a solution.

xlAsh

[Solomon14all]

Dear JosephP,
Sorry for writting in CAPITAL. I am not very much awar of this.

in the attachment. in B2 i will type mannually Emp. No. then i need macro to filter the detail of that paritular Emp. No.

Regards,
Raj.

[JosephP]

change the code to

Please Login or Register  to view this content.

[Solomon14all]

Dear Joseph,

Can you do this workout in the attach excel sheet. and resend me the attachment. becasue i dont no how to do it. however i will try doing by myself and chek with it is working or not.

Regards,
Raj

[Solomon14all]

Joseph,

Thanks a lot i have done it all by myself.

it is now working.

Regards,
Raj.

[JosephP]

good job :-)