hello everyone - I am hopeful and frazzled.. here goes! the following is what I'm working with (a representation at least!)
it's 1 of 2 worksheets in my project, this one is called "source report". I'm needing to populate a second sheet which is very similar, but with a new row being made for each part listed in the csv substring in the "description" column. The full project will have possibly hundreds of comment cells and several will be duplicates I will want to get rid of. I have a second list I'm working on that is a "conversion tool" - a list of the 2-letter 'tag' id's that are part of the "part number" for each part...that should allow me to populate the "part classification" column pretty well. The "parent" column is for a hierarchy listing..the 2nd report image will explain that more clearly, but basically the parts that are capable of being a "parent" are of a different ID convention...only a few designations....
here's "SOURCE REPORT"
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL></COLGROUP>
....and here's "FINAL REPORT" with the populated fields...shortened up some
. The "description" column doesnt need all those blank lines, but I havent even worried about that yet - just formatting I suppose.
So as I am a green excel user I have been readin and I see references to array finctions and macros - I dnon't know any programming.
ANY help would be GRATELY appreciated...
Thanks folks!
<TBODY>
</TBODY>
it's 1 of 2 worksheets in my project, this one is called "source report". I'm needing to populate a second sheet which is very similar, but with a new row being made for each part listed in the csv substring in the "description" column. The full project will have possibly hundreds of comment cells and several will be duplicates I will want to get rid of. I have a second list I'm working on that is a "conversion tool" - a list of the 2-letter 'tag' id's that are part of the "part number" for each part...that should allow me to populate the "part classification" column pretty well. The "parent" column is for a hierarchy listing..the 2nd report image will explain that more clearly, but basically the parts that are capable of being a "parent" are of a different ID convention...only a few designations....
here's "SOURCE REPORT"
| part number</SPAN> | parent</SPAN> | part clssification</SPAN> | category</SPAN> | DESCRIPTION</SPAN> |
| 346-QT-74-ZZTOP</SPAN> | Description: Consists of ZZ704A, TAH704, TH704, LSL704, LAL704, XY704D, TP704A, MP704, P704, E704, FV704, 97LX4235, XK704, RS704B, AL704B, 50GT21, 46LW051, PH704C, RV704, HP704. 52GT704(Control System Board) on EZ-21013. Loss of function will allow the engine to overheat and fail.</SPAN> | |||
| 97LX4235</SPAN> | Description: Consists of ZZ704A, TAH704, TH704, LSL704, LAL704, XY704D, TP704A, MP704, P704, E704, FV704, 97LX4235, XK704, RS704B, AL704B, 50GT21, 46LW051, PH704C, RV704, HP704. 52GT704(Control System Board) on EZ-21013. Loss of function will allow the engine to overheat and fail.</SPAN> | |||
| 46LW051</SPAN> | Function: Cup holder for 79LX522 assy of 50GT21, 50AC021, 50AC021A. Mounting bracket 50LW020 ships seperately</SPAN> | |||
| 50GT019</SPAN> | Function: Cup holder for 79LX522 assy of 50GT21, 50AC021, 50AC021A. Mounting bracket 50LW020 ships seperately</SPAN> | |||
| 50GT21</SPAN> | Description: Consists of ZZ704A, TAH704, TH704, LSL704, LAL704, XY704D, TP704A, MP704, P704, E704, FV704, 97LX4235, XK704, RS704B, AL704B, 50GT21, 46LW051, PH704C, RV704, HP704. 52GT704(Control System Board) on EZ-21013. Loss of function will allow the engine to overheat and fail.</SPAN> | |||
| 50AZI015</SPAN> | Function: Consists of 50LW021, WT019C, KC019C, WK019C and AZI019C. Climate control assy for the LW model. Additional Options allow for custom design depending upon model LW, GT or RS</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL></COLGROUP>
....and here's "FINAL REPORT" with the populated fields...shortened up some
. The "description" column doesnt need all those blank lines, but I havent even worried about that yet - just formatting I suppose.
So as I am a green excel user I have been readin and I see references to array finctions and macros - I dnon't know any programming.
ANY help would be GRATELY appreciated...
Thanks folks!
<TBODY> </TBODY><COLGROUP><COL><COL><COL><COL><COL></COLGROUP> |
<TBODY>
</TBODY>
