Hi again
I have now massively learned from your code and used this knowledge to sort out a another report that I use at work. I'm almost done but there is a last obstacle that I can not figure our myself.
this is my current code
The following two sections are the key sections that I think that would need some sort of editing.
I especially struggle to convert this following information
Column AF ------ Column AG
(Location) ------ (Delivery note)
PLT20 03 028 ------ RN-211073
PLT20 03 028 ------ RN-211072
C21 03 019 ---------- RN-211511
GAR 100C ------------ RN-211510
GAR 100C ------------ RN-211508
GAR 100C ------------ RN-211512
GAR 100C ------------ RN-211513
into this:
PLT20 03 028--> RN-211073, RN-211072; C21 03 019--> RN-211511; GAR 100C--> RN-211508, RN-211512, RN-211513
I have left some comments and sheets before and after on attached xls. Current macro is also attached.
Please note I have changed column AL-s font color into white so its more clearer view. Otherwise text flows from one column to next one.
If anyone can help me I would be vary thankful.
Cheers
Rain
Bookmarks