rwmill9716
Active Member
- Joined
- May 20, 2006
- Messages
- 493
- Office Version
- 2013
- Platform
- Windows
The sheet shown, Complaints, lists on each row information on a single complaint. This information extends from Col A to Col Y (though not that way here, the data actually begins in row 3). I want to highlight a Customer cell, say H227 for Customer A, then activate a macro that (1) recognizes the active customer (here A), searches the list, identifies each row where A is the customer and then writes each row into sheet "Event" beginning in row 4. I should then see the same A to Y cells of information, beginning in row 4, filled in sheet Event for the six customer A complaints. Note, the actual data in sheet Complaints involves 300 rows of data, and over 100 customers can be on the list, some up to 15 times. I know that I could do this by filtering the data, copying and pasting, but a simple macro would be quicker for the group of individuals involved. Note, I then use this information to populate a chart.
Thanks very much for your help,
ric
Thanks very much for your help,
ric
Excel 2010 | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | |||
226 | # | INITIATION Month | INITIATION DATE | CRM Transaction ID | Sales Order | Sales | SHIP Plant | CUSTOMER | CITY | ST/PROV | PRODUCT | Product | Lbs Involved | PROBLEM | Complaint Category | Complaint Sub Category | INITIATOR | INVESTIGATOR | STATUS | CARRIER | DATE CLOSED | DAYS TO CLOSE | Month Closed | Month Closed | Days Outstanding | ||
227 | 1 | Nov | 11/09/12 | 5114885 | 301253256 | C | CB | A | Sjarkaj | Dubai | NTA,POWDER,BAG25KG,40BAGS/P | NTA | 44,000 | Goods Infested with Termites | Pack-Out | Other | Msente | Larry Lavoie | Complete | 1/8/2013 | 60 | 1 | Jan | 1 | |||
228 | 2 | Dec | 12/05/12 | 5115193 | 301260656 | A | CB | B | Guangzhou | CHINA | NTA,POWDER,BAG,25KG,40BAGS/P,ASIA | NTA | 2,200 | Quality Issues | Quality | Product Performance | SSSU | J. Perkins | Complete | 2/5/2013 | 62 | 2 | Feb | 2 | |||
229 | 3 | Dec | 12/11/12 | 5115325 | 30122111 | B | Dec | B | Shanghai | China | INT,HMD,REFINED,100%,BULK,SOLID | HMD | 3,000 | Weight Discrepency | Pack-Out | Weight Discrepancy | DAMARR | Russell Husfeld | Complete | 1/22/2013 | 42 | 1 | Jan | 3 | |||
230 | 4 | Dec | 12/12/12 | 5115332 | 301264681 | A | CB | C | QB | Canada | NTA,POWDER,UNLINED | NTA | 11,013 | 5 SS Not Shipped | Distrib/Warehouse | Picking & Packing | MBSCHE | Christine Iaconis | Complete | 1/22/2013 | 41 | 1 | Jan | 4 | |||
231 | 5 | Dec | 12/12/12 | 5115343 | 301261675 | A | Dec | D | Shanghai | China | INT,HMD,REFINED,100%,Bulk Solid | HMD | 7,339 | Low ISO Weights | Pack-Out | Weight Discrepancy | DAMARR | Russell Husfeld | Complete | 1/22/2013 | 41 | 1 | Jan | 5 | |||
232 | 6 | Jan | 01/07/13 | 5115715 | 301260865 | A | Dec | A | Germany | INT,HMD,Refined,100%,Bulk, Solid | HMD | 40,393 | Port date should be delivery date | Transportation | Delivery - Late | D.Marron | D. Marron | Complete | 1/16/2013 | 9 | 1 | Jan | 6 | ||||
233 | 7 | Jan | 01/08/13 | 5115760 | 301266808 | A | Pns | A | Cincinnati | OH | Adipic, Resin, 258, FF, 2000lb, C-Bag, 45x45P | ADIPIC | 44,000 | Carrier ran out of hours | Transportation | Delivery - Late | W.Gummere | Tim Martin | Complete | CH Robinson | 1/16/2013 | 8 | 1 | Jan | 7 | ||
234 | 8 | Jan | 01/09/13 | 5115783 | 301266743 | A | Pns | A | Kingsport | Tn | Adipic, Resin, 220, FF, 2205lb, 1Bag/P | ADIPIC | 88,200 | Late deliveries (2) | Transportation | Delivery - Late | W.Gummere | Tim Martin | Complete | Heartland Express | 1/29/2013 | 20 | 1 | Jan | 8 | ||
Complaints |