PDA

View Full Version : Sleeper: Apply Filter ? Modify Resulting Columns



Carpiem
07-26-2006, 09:32 AM
“Good Morning”,

There are 3 sheets in the attached “WarrantyCosts” file - no macros exist.

1. “Warranty$$” sheet data is copied / transposed to “Mid” sheet.

2. “Mid” sheet Group column “A” is filtered. Having selecting “Drives”, data is copied / transposed to the “Final” sheet.

Only the Drives & General groups were processed for illustration. In reality, all eleven (11) Groups listed would be in the “Final” sheet table.

3. The data in the “Final” sheet is copied to columns E-F. The Group column is inserted, Titled and filled down. The table is sorted by “WarrantyCosts-YTD” column. Any Customer with $0.00 Warranty Costs is deleted.

------------------------------------------------

Step 1 is solved. (MD Mackillop cleaned my code. “Thank you Malcolm”). :thumb

Steps 2 & 3 are where I need help.

As a manual task it is repetitive and time consuming. Usually 300-500 Customers would be on the “Warranty$$” sheet.

Thank you in advance…. Carpiem