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.
work-excel.blogspot.in is an excel based blog with lot of regular vba microsoft excel function which will allow you to smartly work in excel. It explains some basic microsoft excel string function in basic steps.
Showing posts with label Split in to several sheet. Show all posts
Showing posts with label Split in to several sheet. Show all posts
Saturday, March 24, 2012
Subscribe to:
Posts (Atom)