Filter and Copy to secondary sheet
Posted by Jeanne on May 03, 2000 5:47 PM
I have an Excel 2000 file that is used to track sales which contains information regarding service provided, price, etc. After a month's entries are posted to the first worksheet (called dailylog), the rows are sorted by Customer Name. I have setup the Automatic Filter and have done a "record macro" to filter, copy, paste to secondary sheet, return to dailylog and undo the filter, but this macro will have to be changed quite often as the next month's dailylog sheet may not have the same amount of entries for each customer. Is there a way to have Excel look for a particular text as the customer name (listed in column A), grab ONLY the rows that contain that text, and then copy the rows to a secondary sheet (customer name sheet) to track the monthly items for a particular customer? Please help!! Thank you !!