|
Registered
Join Date: Jan 2002
Location: Nor California & Pac NW
Posts: 24,867
|
For each model (911, 914, etc), I would copy the part numbers (col B), paste-transpose that into a row, use that row to drive a VLOOKUP formula to create a table that extracts the info you want, in the format you want, and then copy-paste values that table to remove the formula and convert the table to hard-coded values. But I actually think the format you have is potentially more useful.
__________________
1989 3.2 Carrera coupe; 1988 Westy Vanagon, Zetec; 1986 E28 M30; 1994 W124; 2004 S211
What? Uh . . . “he” and “him”?
Last edited by jyl; 01-22-2010 at 10:34 AM..
|