Hi all,

I'm new to this forum but I'm hoping someone here might be able to help me.

I have a workbook that I am trying to clean up. Ideally, the selection of a region in Column A (denotated as green) would sort specific rows of data into the 3 other worksheets. For example, the raw data would be pasted in to the general worksheet and then be coded by region. This would trigger the sorting process to pull specific, critical columns onto a cleaner page. Right now, I am filtering by region and pasting in the results.

I'm new to macros, but after reading some of the other postings and forums around the internet, it seems as though it is possible to automate te process. I've tried my best but am struggling to create a functional method.

Any ideas? Thanks in advance. I apologize for butchering any terminology.

Sample.xls