Filter into respective sheets

[Akinrotimi]

Hello,

I have a huge data of 70,000 rows with a column relating to the UserID of the person who posted the transaction.There is a dedicated sheet for each user(85 sheets in all).

This is a routine report showing the transactions posted by a user in the sheet created for him/her.

Any macro to speed up this routine report?

Thanks in advance.

Rotimi

 

[VoG]

See if this helps http://www.mrexcel.com/forum/showthread.php?t=396069

Note that both Excel Explosion and my code will create the user sheets - you should not create these yourself.

 

[Akinrotimi]

Perfect!

Thanks a mill.

Cheers

Rotimi