Hello, the undesired blank rows shouldnt even appear, the code shouldnt, for example in Agosto, the report obtained is the following
Tuxpan
CTT Ventana
GSR-C
GSP-RP
GSP-C
MTBE
GSRUBAZMVM
CTT 17/08/201519/08/2015
CTT 29/07/201531/07/2015
CTT -
CTT 02/09/201504/09/2015
GSRUBAZMM
GSPUBAZMVM
GASOLINE BLENDSTOCK
TERCERIAS
Excel looks for every Puerto, each different products, if theres info about the product like CTT and the other this, it should be displayed right under the product. If there is no information in the table it should put the next product and so on for every product. The products are
GSR-C
GSP-RP
GSP-C
MTBE
GSRUBAZMVM
GSRUBAZMM
GSPUBAZMVM
GASOLINE BLENDSTOCK
TERCERIAS
When we ask the report for Septiembre, we get the following:
Tuxpan
CTT Ventana Buquetanque
GSR-C
GSP-RP
GSP-C
MTBE
GSRUBAZMVM
CTT - C
CTT 02/09/201504/09/2015 A
GSRUBAZMM
GSPUBAZMVM
GASOLINE BLENDSTOCK
TERCERIAS
the report instead should look like this:
Tuxpan
CTT Ventana Buquetanque
GSR-C
GSP-RP
GSP-C
MTBE
GSRUBAZMVM
CTT - C
CTT 02/09/201504/09/2015 A
GSRUBAZMM
GSPUBAZMVM
GASOLINE BLENDSTOCK
TERCERIAS
after each Puerto (like Tuxpan, Pajaritos) theres the desired blank row i was talking about
Rosarito
CTT Ventana
GSR-C
GSP-RP
GSP-C
MTBE
GSRUBAZMVM
GSRUBAZMM
GSPUBAZMVM
GASOLINE BLENDSTOCK
TERCERIAS
<------ here
Lázaro Cárdenas
CTT Ventana
GSR-C
GSP-RP
GSP-C
MTBE
GSRUBAZMVM
GSRUBAZMM
GSPUBAZMVM
GASOLINE BLENDSTOCK
TERCERIAS
The code that does this is the following:
I think the problem is where the nested for are with the counters of variable "c".
I hope this explains better what the problem is. Thanks a lot!
Bookmarks