How to create a button to auto copy filtered data from a master sheet to other sheets

please post sample workbook

Will do so as soon as i translate it to English, because it is in Greek right now..
Thank you for the prompt answer!

unfortunately error comes up when trying to download your workbook on the above link. Why do not you try to use forum functionality:

What Are Attachments?
The administrator may allow you to use the attachment feature of this forum, which gives you the ability to attach files of certain types to your posts. This could be an image, a text document, a zip file etc. There will be a limit to the file size of any attachments you make, as the forums should not be used as an extension of your hard disk!

To attach a file to a new post, simply click the [Browse] button at the bottom of the post composition page, and locate the file that you want to attach from your local hard drive.

Only certain types of files may be attached: these are the valid file extensions for files to be attached to this forum: .

After posting, the attachment will show up in the body of your message. To view the contents of the attachment (if it is not already displayed) simply click the filename link that appears next to the attachment icon .

http://www.excelforum.com/faq.php?fa...chment_explain

My mistake, please check the link again!! TESTED!
http://dl.dropbox.com/u/3791855/Exce...8Food%29_1.xls

save attachment and make sure the following reference is on:

1. [Alt+F11] - open Visual Basic window
2. Tools - References - find and tick "Microsoft Activex Data Objects 2.0 Library"
3. press "Start"

THANK YOU VERY MUCH WATERSEV!! It works like a charm!
I am deeply thankful!

I will try to learn from your code and build on it..

Is there a way to automatically sort the new sheets (Teachers, Students) according to a custom order firstly AND then by name?

First sort by Teacher, Student, Nurse, Cleaning
then sort by Name?

Lets say:

Teacher___Arts____Aname
Teacher___Arts____Bname
Teacher___Arts____Cname
Teacher___Sports__AAname
Teacher___Sports__BAname

Hope i am not a big pain. Thank you for your help.

save attachment and make sure the following reference is on:

1. [Alt+F11] - open Visual Basic window
2. Tools - References - find and tick "Microsoft Activex Data Objects 2.0 Library"
3. press "Start"

I've noticed a bloody mistake in the code (mistake in field number for cleaning). The mistake is corrected, sorting added though it might be not what you wanted

Unfortunately, i broke my laptops' LCD.
The cable got caught in my legs and just pulled it off the desk and crashed it..
For now i am forced to post from an internet cafe..
I will be back soon, thank you for the posts..

Looking for an ASUS lcd panel now for my EEE PC.. pff..