Sorry, the post seems like it works because it has less data than the document I'm actually trying to organize. The macro separates data that matches one condition and puts it in a new sheet but the data starts on the second row and my data starts on the 5th row because I have to put some title information before the data. So I thought that the macro didn't work on my document because the data started on the 5th row, however after trying another code that does a similar function, the error was that the data was over flowing so it was past the capacity and had to be labelled as "long" instead of "integer". I'll post that code too and maybe it can give you an understanding but this code doesn't have dim as long so I don't know how to call out the values in the cell to be long. Hopefully I described that well enough. Thanks for following up with me.
Bookmarks