I have a worksheet (2003) with data of tiems being sent out in the post, for each devision in the company.
I want to filter this data to just show my devision on a seperate spreadsheet, within the same workbook.
hope that makes sence?!
I have a worksheet (2003) with data of tiems being sent out in the post, for each devision in the company.
I want to filter this data to just show my devision on a seperate spreadsheet, within the same workbook.
hope that makes sence?!
I have done this using Code. The basic premise I used was within a range if the rowIndex.Hidden was true then the item was filtered if false then copy elsewhere.
Hope this gets you started...Please Login or Register to view this content.
Last edited by tkowal; 10-06-2011 at 02:58 PM. Reason: Putting proper tags in the text
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks