thanks... Here is the details: Geniri ID Year Cutoff Lot info I23 I23 1991 23 I24 I24 1999 44 I25 I25 2001 33 I26 I26 2004 11 I27 I27 2006 15 I28 I28 2007 22
Parts Description Tring Vehicle type Make Year Color Cushion Auction Lot Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 Brakes Ultra Tweek Barakes 2 99 Mazda 2003 Black 3444 12900 After run ( Here is the desired result): Geniri ID Year Cutoff Lot info I23 I23 1991 23 I24 I24 1999 44 I25 I25 2001 33 I26 I26 2004 11 I27 I27 2006 15 I28 I28 2007 22 Parts Vehicle type Make Year Cushion Auction Lot Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 Brakes 99 Mazda 2003 3444 12900 As you see the headers start in the middle..Any thing above headers arestatic info, and would like keep there. Thanks again -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
