Newbie at Macros - tips for seemingly simple macro?

Hello All,

I am working on a project that currently does not include a great deal of data, and could easily be sorted by hand. However, this data is expected to increase exponentially, and I will thus need to create a macro that can do the following:

Macro that starts with the contents of one file and splits them out by group (column C in this case), and creates a separate file for each group with all of the same information that is in this file. The group name should be include in the title.

If anyone would be so kind as to offer me some help in creating this macro, I would greatly appreciate it.

Thanks in advance!

I've also found that attaching an example file (or the actual file if possible) helps the gurus help you.

The file included some data that I probably shouldn't share publicly, but I changed the names and removed the columns with figures. However, I can't seem to find an option to attach the file anywhere... sorry, it's been a while since I've posted here.

If you click "Go Advanced" instead of using quick reply, there should be a new icon of a paperclip so that you can attach a file

Copy of general 2015 percentages.xlsx

Here it is, thanks!

Below is the code that was generated. Basically, I just use advanced filter to copy only the data from my chosen category (group, Column C) to another location within the same workbook, and then I copy that data, paste it to another workbook, and save it to a location and file name of my choice.

Sub Macro3()
'
' Macro3 Macro
'

'
Range("A8:AE40").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
"A2:AE3"), CopyToRange:=Range("A45"), Unique:=False
Rows("45:52").Select
Selection.Copy
Windows("Book1").Activate
ActiveSheet.Paste
Windows("general 2015 percentages.xlsx").Activate
End Sub

Oh, I forgot to record the saving process, but when I redid it, it worked just like I wanted it to. However, I still want to be able to do the following:

-Create a button on the spreadsheet that will run the macro with just one click

-I want each file to save as 'Whatever the category is' followed by 'today's date and time, i.e. 072220151532'

Would appreciate any help for these two things, or any suggestions to improve what I already have so far. Thanks!

Thanks very much for the help Richard. This is very close to working perfectly - however, each file is being saved with the wrong name, i.e. category PR being saved as APxxxxxxxxxx.

Yep, that works - thanks very much!