Copy rows into new sheet based on cell/column data

[StagemanGraham]

I am trying to create a set of spreadsheets that track expenses. I have a sheet "Record" that I would like to have data copied from into a series of other sheets based on the values of cells in a specific column. For example, I'm recording expenses, one of the columns of data is "production name," and I'd like to copy the remaining data into a new sheet for each unique show. I don't think Vlookup would work because I'm looking to copy several records across a number of dates, which is one of the other data columns.

I'm not a VB guy, so I'm kind of clueless. Any help is appreciated.

[JBeaucaire]

'SHEET1 TO MANY SHEETS
Here's a macro for parsing rows of data from one sheet to many sheets named for the same values in a specific column.

Sheet1 to Many Sheets

It not only can parse the rows, it can create the sheets if they are missing. There is a sample sheet there where you can test this out.

[JBeaucaire]

How'd that work for you?

If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.