I have a worksheet which consists of records from different years. One of the columns displays the year such as "2004" etc.
What I would like to do is move the data to individual worksheets based on year. So I would end up with all the year 2004 records on one sheet, 2005 on another, etc. Then I would like to name the sheet based on the year.
I need to do this with a macro.
Any help would be greatly appreciated. Thanks.
kaufmann98,
Welcome to the forum!
Give the below code a try. You'll need to update the strYearCol to the appropriate column.
Please Login or Register to view this content.
Last edited by tigeravatar; 06-11-2012 at 01:48 PM. Reason: Updated code to include a sort
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks