Showing posts with label Macro to split excel sheet. Show all posts
Showing posts with label Macro to split excel sheet. Show all posts

Saturday, March 24, 2012

Split excel in to several sheets based on column data?

While working on yearly reports or data you have for several users. You have the consolidated data in to several sheets based on year or user names. This can be easily achieved by macro. Please find below an example and a macro to achieve this.