{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["VENTAS MENSUALES"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"VENTAS MENSUALES","index":0,"n_rows":20,"n_cols":18,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,2,2,17],[0,0,1,16]]}
["La aplicación, Application.ScreenUpdating = False en este ejemplo nos sirve para congelar la pantalla y el proceso que realiza la macro sea más rápido y no se aprecie la ejecución de los resultados según lo establecido en la Macro."]
[]
[null,null,"VENTAS MENSULES DE LOS ÚLTIMOS 15 AÑOS"]
[null,null,null,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015]
[null,null,"ENERO",450090,450180,450270,450360,450450,450540,450630,450720,450810,450900,450990,451080,451170,451260,451350]
[null,null,"FEBRERO",451440,451530,451620,451710,451800,451890,451980,452070,452160,452250,452340,452430,452520,452611,452702]
[null,null,"MARZO",452793,452884,452975,453066,453157,453248,453339,453430,453521,453612,453703,453794,453885,453976,454067]
[null,null,"ABRIL",454158,454249,454340,454431,454522,454613,454704,454795,454886,454977,455068,455159,455250,455341,455432]
[null,null,"MAYO",455523,455614,455705,455796,455887,455978,456069,456160,456251,456342,456433,456524,456615,456706,456797]
[null,null,"JUNIO",456888,456979,457070,457161,457252,457343,457434,457525,457617,457709,457801,457893,457985,458077,458169]
[null,null,"JULIO",458261,458353,458445,458537,458629,458721,458813,458905,458997,459089,459181,459273,459365,459457,459549]
[null,null,"AGOSTO",459641,459733,459825,459917,460009,460101,460193,460285,460377,460469,460561,460653,460745,460837,460929]
[null,null,"SEPTIEMBRE",461021,461113,461205,461297,461389,461481,461573,461665,461757,461849,461941,462033,462125,462217,462309]
[null,null,"OCTUBRE",462401,462493,462585,462678,462771,462864,462957,463050,463143,463236,463329,463422,463515,463608,463701]
[null,null,"NOVIEMBRE",463794,463887,463980,464073,464166,464259,464352,464445,464538,464631,464724,464817,464910,465003,465096]
[null,null,"DICIEMBRE",465189,465282,465375,465468,465561,465654,465747,465840,465933,466026,466119,466212,466305,466398,466491]
[null,null,null,{"$f":"SUM(D5:D16)","v":5491199},5492297,5493395,5494494,5495593,5496692,5497791,5498890,5499990,5501090,5502190,5503290,5504390,5505491,5506592]
[]
["Para poder apreciar el desarrollo de la Macro, eliminar todo lo realizado en la tabla, ir a Visual Basic, click en Hoja2 y finalmene poner en marcha a la macro con F5."]
["No dejar de lado que el proceso será más lento y se apreciaran los cálculos si cambiamos la aplicación a : Application.ScreenUpdating = True."]