PDA

View Full Version : VBA to Filter Excel Data to a Different Sheet



mambo84
03-11-2010, 07:33 AM
Hi

Looking for a VBA which can help to move a specific bundle of data from the source sheet to separate worksheets.

Eg. data listed in same column, from a single source worksheet, which contains any related words to ''car", "tele" & "mobile". They would be auto-sorted to differrent worksheet (Eg. worksheet Car, worksheet Tele & worksheet Mobile) and subtotal in each new worksheet.

Thx.

Bob Phillips
03-11-2010, 08:38 AM
Cross-posted at XtremeVBTalk http://www.xtremevbtalk.com/showthread.php?t=314461

lucas
03-11-2010, 08:46 AM
mambo84, please read this (http://www.excelguru.ca/node/7).