[QUOTE=Giraffe;9547]Thanks Rick for trying but assuming I have entered it correctly and run it correctly it came out as attached. At the momenThe reason the code did not work for you is because I designed it for this (which came from the workbook you attached to Message #4)...Originally Posted by Giraffe
A B C D E F 1 100mic Gloss Film 1000mm x 100m on 78mm core FP22GLO100001003K 22 1000 100 3 2 100mic Gloss Film 1400mm x 1400m x 78mm core FP22GLO140014003F 22 1400 1400 3 3 125mic Gloss Film 230mm x 60m on 58mm core FP23GLO023000602 23 230 60 2 4 125mic Gloss Film 230mm x 100m on 58mm core FP23GLO023001002OUT 23 230 100 2 5 75mic Ultra Matt Film 110mm x 1000m on 78mm core FR12MAT011010003 12 110 1000 3
but this is from the workbook you attached to Message #9 which you say my code did not work for...
A B C D E F 1 UBG315X500X77 ULTRABOND GLOSS 315mm 500m 77mm core 315 77 77 7 2 UBG315X500X77 ULTRABOND GLOSS 315mm 500m 77mm core 315 77 77 7 3 UBM315X500X77 ULTRABOND MATT 315mm 500m 77mm core 315 77 77 7
Does anything look different about those two layouts to you? Because they sure look different to me!
Now, what does your data layout actually look like... the first or second table above?
Reply With Quote
Bookmarks