I have a spreadsheet with all the reports and studies, under the coloum
coding, I classify them as BS- for building structure, WA- water, SW -
sidewalk, TE - telecommunication. Some of the reports has 2 to 3 coding
listed on it, so I place such code and separate them using comma - BS, WA,
TE.

I s there any way or maybe a macro that I can sort my reports by individual
code, like BS only or WA.

Maybe you don't need to sort the data.

I'd add headers (if you don't have them already)
Then select the column with those codes and use
data|filter|autofilter

You can use the custom option and use Contains BS (for example).

Jay wrote:

I have a spreadsheet with all the reports and studies, under the coloum
coding, I classify them as BS- for building structure, WA- water, SW -
sidewalk, TE - telecommunication. Some of the reports has 2 to 3 coding
listed on it, so I place such code and separate them using comma - BS, WA,
TE.

I s there any way or maybe a macro that I can sort my reports by individual
code, like BS only or WA.

--

Dave Peterson