Automatically transferring data from one sheet to another dependent upon category

Goal:
Automatically transfer data in a particular sheet to other sheets depending on the category "service".
Example:
Sheet name = MBTF
Columns: Date, Client ID, Client Name, Service, Description, Qty, Price, Total

Based on this sheet, I would like to automatically transfer data by clicking a Command button to different sheets within the workbook dependent upon the category "service". I would like to create a template for each "service" and create a tab for each "service" and automatically transfer Date, Client ID, Client Name, Description, Qty, Price and Total.

I do not how to create the VBA code for this. I need to run these reports every month.

Please help.

Thank you!! :o)

Wow Thank you so much! I wish I could decipher that and use it with my spreadsheets but I'm a total beginner to VBA and don't know how to personalize to my sheet.

If anyone can break it down a little further that'd be wonderful!

Does this help?

Please Login or Register  to view this content.